How we can convert rows to columns in datastage?
Answer Posted / upputuri.vinod
Bro that's right I have another ans as-well..
I am going to use copy and funnel stages to implement the
pivot functionality.
name ph1 ph2---> copy--->cp1 name ph1
| funnel---->o/p
|____>cp2 name ph2
CP1 and CP2 are the TWO links from COPY..
in cp1 we have the name and ph1 where in cp2 name and ph2.
In funnel stage i am going to club the two links and send it
to o/p.
THE BENEFIT IN THIS IS WE CAN USE PIVOT UPTO 3250 ROWS
ONLY.. AFTER THAT IT WONT WORK..
SO WE CAN USE IT...
Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
What all are the different way to run a job?
How many areas for files does datastage have?
What is the difference between odbc and drs stage?
How do you generate sequence number in datastage?
What is the purpose of interprocessor stage in server jobs?
What is apt_config in datastage?
Which commands are used to import and export the datastage jobs?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How we can covert server job to a parallel job?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How to read the length of word in unix?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?