Load 10000 Records into Dynamically Created 100 Files

How to load 10000 records into dynamically created 100 files and to load 100 records in each?

Showing Answers 1 - 3 of 3 Answers

Snehasis

Sep 11th, 2015

This can be done using TC transformation. In an expression before the TC, keep a counter which increments for each row passed. When the counter reaches 100, reset the counter to 0.
In the expression create a filename port and in the TC write the follwoing: IIF(count=100,TC_COMMIT_BEFORE,TC_CONTINUE_TRANSACTION). In the target create a filename port and connect it.