please tell me the logic for this....

thirupathireddy.gankidi · Tue Feb 21, 2012 10:11 am

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

DSguru2B · Post by **DSguru2B** » Tue Feb 21, 2012 11:05 am

You want loop and duplication. What version of datastage are you on?

qt_ky · Post by **qt_ky** » Tue Feb 21, 2012 1:25 pm

Transformer stage looping in DataStage 8.5 or higher can do exactly that.

thirupathireddy.gankidi · Tue Feb 21, 2012 10:13 pm

i am using datastage 8.5 version

DSguru2B · Post by **DSguru2B** » Wed Feb 22, 2012 8:05 am

Do what Eric suggested.

qt_ky · Post by **qt_ky** » Wed Feb 22, 2012 7:16 pm

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.

thirupathireddy.gankidi · Wed Feb 22, 2012 10:02 pm

Thanks Eric