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
On which Dimension Table you implemented SCD Type in your Project
how many rows sorted in sort stage by default in server jobs
What is the use of datastage director?
why do u need the IOS upgradation in a FC switch
Name the different types of Lookups in Datastage?
Explain datastage architecture?
Can you explain tagbatch restructure operator?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Where the datastage stored his repository?
What are some different alternative commands associated with "dsjob"?
Describe the main features of datastage?
what is use of SDR function?
What is a datastage job?
How to read the length of word in unix?