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
Answers were Sorted based on User's Feedback
Answer / 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 |
To see hidden files in LINIX?
in oracle target stage when we use load option and when we use upsert option?
how to sort two columns in single job in datastage.
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the processing stages?
What is Fastly Changing Dimension?
Can you explain kafka connector?
what is the exact difference between dataset and fileset in datastage?
How to reverse the string using unix?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How a server job can be converted to a parallel job?
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance