Loop a source file specified times and loading in target

[antojj]

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,

[khanparwaz]

Hi
Their a start loop activity & end Loop activity in datastage
Make use of that in sequence & put your job which loads the file in between that loop

In the property of start loop specify loop type as numeric

& in loop definition specify in from 1 step 1 to 10.


this will run ur file load job 10 times.