Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 8616 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / venu
Use Pivot stage......
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
Describe the main features of datastage?
How one source columns or rows to be loaded in to two different tables?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How many Key we can define in remove duplicate stage?
What are datastage sequences?
How to find value from a column in a dataset?
What are the types of jobs we have in datastage?
What are routines in datastage? Enlist various types of routines.
Whats difference betweeen operational data stage (ods) and data warehouse?
Why do we use link partitioner and link collector in datastage?
What is the use of datastage director?
What is job control?
What are the types of containers?
What is the difference between passive stage and active stage?
What are the repository tables in datastage?
