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 / venu
Use Pivot stage......
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
If you want to use a same piece of code in different jobs, how will you achieve this?
what is the use of surogate key in datastage
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Define ds designer?
How we can covert server job to a parallel job?
How can we improve the performance in datastage?
How many types of views are there in a datastage director?
What is a datastage job?
What are the components of ascential data stage?
How can one find bugs in job sequence?
What are the steps required to kill the job in Datastage?
Can you filter data in hashed file?
Explain the situation where you have applied SCD in your project?
What is the difference between the local container and shared container?
What are the types of jobs we have in datastage?