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
- 8509 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
How can we improve the performance in datastage?
What are the functionalities of link collector?
If you want to use the same piece of code in different jobs, how will you achieve it?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the difference between operational data stage (ods) and data warehouse?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the various kinds of containers available in datastage?
What are the different common services in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the areas of application?
Describe the main features of datastage?
What are the types of hashed files in data stage
how to write server Routine coding?
What is datastage engine?
whom do you report?
