Page 1 of 1

please tell me the logic for this....

Posted: Tue Feb 21, 2012 10:11 am
by thirupathireddy.gankidi
Hi,
can anyone please tell me the logic to implement this scenario...


my source is coming like,

id
---
2
5
3

and target is,

id
---
2
2
5
5
5
5
5
3
3
3


Thanks in advance


Regards,
------
Thiru

Posted: Tue Feb 21, 2012 11:05 am
by DSguru2B
You want loop and duplication. What version of datastage are you on?

Posted: Tue Feb 21, 2012 1:25 pm
by qt_ky
Transformer stage looping in DataStage 8.5 or higher can do exactly that.

Posted: Tue Feb 21, 2012 10:13 pm
by thirupathireddy.gankidi
i am using datastage 8.5 version

Posted: Wed Feb 22, 2012 8:05 am
by DSguru2B
Do what Eric suggested.

Posted: Wed Feb 22, 2012 7:16 pm
by qt_ky
Thiru, visit the loop section of the Parallel Job Developer's Guide. It has pretty good examples that can help you on this. The PDF should be installed on your client by default.

Posted: Wed Feb 22, 2012 10:02 pm
by thirupathireddy.gankidi
Thanks Eric