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 is usage analysis in datastage?
how to sort two columns in single job in datastage.
What can we do with datastage director?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How do you remove duplicate values in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Explain entity, attribute and relationship in datastage?
What is the command line function to import and export the ds jobs?
describe the Steps to confiure a Qlogic switch
To see hidden files in LINIX?
What are the different common services in datastage?
What are the functionalities of link collector?
What are the primary usages of datastage tool?
What are the enhancements made in datastage 7.5 compare with 7.0?
How many Key we can define in remove duplicate stage?