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
- 7937 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
How to manage date conversion in Datastage?
What are the partitioning techniques available in link partitioner?
What is active and passive stage?
What is a datastage job?
What a datastage macro?
How rejected rows are managed in datastage?
What are the types of hashed files in data stage
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Give an idea of system variables.
Explain Quality stage?
Can you explain kafka connector?
What is the purpose of pivot stage?
Name the third party tools that can be used in datastage?
Terminate Activity
