datastage scenario

vijayasarathi7 · Post by **vijayasarathi7** » Mon Dec 14, 2015 5:19 am

source one column name is id
1
2
3

i want target is

id
1
2
3
1
2
3
1
2
3
how you it

qt_ky · Post by **qt_ky** » Mon Dec 14, 2015 6:31 am

You start by stating the requirement in words, and include an example. All you have so far is an example.

chulett · Post by **chulett** » Mon Dec 14, 2015 7:44 am

Yes, please - use your words, don't make people puzzle out your requirement from a made up example.

MrBlack · Post by **MrBlack** » Thu Dec 17, 2015 2:28 pm

Are you trying to triplicate the number of rows you have in the end? Starting out with 3 rows and you want to have 9 in the end? With not having a lot of information here's what you do. Create a sequence with a loop of 3 loops. Then have it run your job three times.

stuartjvnorton · Post by **stuartjvnorton** » Thu Dec 17, 2015 4:57 pm

Thanks, OP. I needed a chuckle this morning.

JKenklies · Post by **JKenklies** » Fri Dec 18, 2015 5:42 am

Please read this sticky thread:

viewtopic.php?t=96330
This will help you to help us helping you.

Add a Transformer stage to your Job with 3 output links. In Transformer, map the ID field to all output links. Then use a Funnel stage to "Union all" the 3 links.