Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 8505 Views
- HCL, I also Faced
- E-Mail Answers
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
Distinguish between informatica & datastage. Which one would you choose and why?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How do you import and export data into datastage?
Can you filter data in hashed file?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the purpose of pivot stage?
What are the types of containers in datastage?
What are the components of datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
How many Key we can define in remove duplicate stage?
what is repositery?
How do you generate sequence number in datastage?
What is the difference between account and directory options ?
what is use of SDR function?
What is meta stage?
