Page 1 of 1
datastage scenario
Posted: Mon Dec 14, 2015 5:19 am
by vijayasarathi7
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
Posted: Mon Dec 14, 2015 6:31 am
by qt_ky
You start by stating the requirement in words, and include an example. All you have so far is an example.
Posted: Mon Dec 14, 2015 7:44 am
by chulett
Yes, please - use your words, don't make people puzzle out your requirement from a made up example.
Posted: Thu Dec 17, 2015 2:28 pm
by MrBlack
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.
Posted: Thu Dec 17, 2015 4:57 pm
by stuartjvnorton
Thanks, OP. I needed a chuckle this morning.
Posted: Fri Dec 18, 2015 5:42 am
by JKenklies
Please read this sticky thread:
viewtopic.php?t=96330
This will help you to help us helping you.
![Idea :idea:](./images/smilies/icon_idea.gif)
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.