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
How to implement complex jobs in data stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the command line function to import and export the ds jobs?
What is the differentiate between data file and descriptor file?
What are the main features of datastage?
Define orabulk and bcp stages?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How do you schedule or monitoring the job?
What is process model?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define project in datastage?
On which interface you will be working as a developer?
What is the difference between passive stage and active stage?
Have you have ever worked in unix environment and why it is useful in datastage?