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
What are the difference types of stages?
What are the job parameters?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the features of datastage flow designer?
What is data partitioning?
Where do you see different stages in the designer?
Why do you need stage variables?
what is the use of skid in reporting?
What is the flow of loading data into fact & dimensional tables?
What are the functionalities of link partitioner and link collector?
Can you implement SCD2 using join, transformer and funnel stage?
How a server job can be converted to a parallel job?
What are the types of jobs we have in datastage?
Define orabulk and bcp stages?
project Steps,hits, Project level HArd things,Solved methods?