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,
Loop a source file specified times and loading in target
Moderators: chulett, rschirm, roy
Loop a source file specified times and loading in target
Antonio D'souza
-
- Participant
- Posts: 60
- Joined: Tue Jul 12, 2005 3:34 am
Re: Loop a source file specified times and loading in target
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.
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.