DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 28

Points: 315

Post Posted: Sat Feb 01, 2020 8:30 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi

I have a requirement as below, I have to achieve the output like the below.
how I can do this with the @iteration variable in transformer and what derivation i have to give in the stage variable and looping variable.Please help me with this

Input record

123

Output

123
123
123
123
123

Thanks
Rakesh
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2890
Location: USA
Points: 21936

Post Posted: Sun Feb 02, 2020 2:34 am Reply with quote    Back to top    

That does not make any sense. Have you tried experimenting?

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Sun Feb 02, 2020 3:50 am Reply with quote    Back to top    

As noted... what?

Put your requirement into words, perhaps even the same words the requirement was given to you with. And if you are going to post an example, use real data rather than some made up junk that doesn't help your cause one bit. Confused

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 28

Points: 315

Post Posted: Sat Feb 08, 2020 6:46 pm Reply with quote    Back to top    

Hi Chulett/qt_ky

I tried using the looping variable @looping <=5 in transformer stage and assigned the input record to this looping variable and I got the ouput as below. thank you all for your inputs

Code:
123
123
123
123
123


thanks
Rakesh
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Sun Feb 09, 2020 3:23 am Reply with quote    Back to top    

And... resolved?

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 28

Points: 315

Post Posted: Wed Feb 12, 2020 7:34 am Reply with quote    Back to top    

Yes.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours