I have a table consists of 2 columns and required o/p is input should be duplicated n times.
n may be 2,3,5
Ex-if n is 2 and no of records in i/p is 3.required o/p is 6 rows(3*2)
I can acheive using looping,copy+funnel stage but want to know is there any single stage in datastage which can get the required output
Duplicating record n Times
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: