Loop a source file specified times and loading in target
Posted: Wed Dec 21, 2005 5:12 am
I have a requirement. I need to use a source file (3 records). Load this data to a target file multiple times in a Loop.
Input file : 3 records
Loop : 10
Output file : 30 records
How can i go about this?
Is there any stage been used to handle this type of transformations?
I could remember in another tool, that there is a counter which increments the loop and you will be prompted with the output data.
But, not sure about datastage. If datastage has the features specified , let me know.
Thanks in advance,
Input file : 3 records
Loop : 10
Output file : 30 records
How can i go about this?
Is there any stage been used to handle this type of transformations?
I could remember in another tool, that there is a counter which increments the loop and you will be prompted with the output data.
But, not sure about datastage. If datastage has the features specified , let me know.
Thanks in advance,