Test A TIBCO Scribe® Online Map Using A Limited Number Of Records
Article ID: KB0078638
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
This article describes how to run a TIBCO Scribe® Online Integration map on a limited amount of records. When testing a map, it can be useful to stop after a certain number of rows, instead of processing them all. Sometimes this is faster than debugging a map step by step. In other cases, you want to test a sample of actual data.
Steps
Use the RECNUM() function, an If/Else Block and a Map Exit control block.
• Edit your Integration Services map. It should contain a Query block and a For Each Result control block.
• Place a Group Block at the top of the For Each Result control block. Name it "Stop after # of records."
• Place an If / else control block in the Group block.
• Add a condition to the If Block - RECNUM() is greater than 100
• Place a "Map Exit" control block under the "If"
• Turn off batch processing in in any blocks where it's activated. This is necessary because the current version of Scribe Online doesn't flush the cache
Pro Tip: By putting the If/Else in a group block, you can drag the group block to the scratch area. This de-activates the block.
Notes:
• By placing the If / else block at the top of the map, it will always be executed. If you put it at the end of the map, it won't get executed on failed records.
• As a result, the execution history will report 1 more record than is actually processed.
• Remember to turn on batch processing before running the maps on all records.
Issue/Introduction
This article describes how to run a Scribe Integration map on a limited amount of records.
Feedback
Yes
No
Powered by
