eno ename esal acct1 acct2 amount1 amount2
100 suresh 10000 sbi1 sbi2 1000 2000
this is our sourse data
i would loke to disply like this
eno ename esal acct amount
100 suresh 10000 sbi1 1000
100 suresh 10000 sbi2 2000
Answer Posted / geetha
Using @iteration=2 looping and define two stage variables and put the if else condition to provide the derivation (ex: @iteration=1 then acct1 else if @iteration=2 then acct2.)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a ds designer?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Describe link sort?
What is a datastage job?
In Datastage, how you can fix the truncated data error?
What is the difference between operational data stage (ods) and data warehouse?
what is ds administrator used for?
What all the types of jobs you developed?
What is the difference between passive stage and active stage?
What is the difference between orabulk and bcp stages?
How a source file is populated?
What could be a data source system?
What is the use of datastage director?
What are the some differences between 7.x and 8.x version of datastage?
Define ds designer?