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
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 is the use of materialized view?
What is the roundrobin collector?
What is the difference between datastage and datastage tx?
What are orabulk and bcp stages?
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...
How to find value from a column in a dataset?
Where the datastage stored his repository?
Why do we use link partitioner and link collector in datastage?
How to Remove Duplicate using SQL?
project Steps,hits, Project level HArd things,Solved methods?
What are transforms and what is the differenece between routines and transforms?
client know skid info?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are stage variables and constants?