Interested to Buy Any Domain ? << Click Here >> for more details...
How we can convert rows to columns in datastage?
- 4 Answers
- 25093 Views
- IBM, I also Faced
- E-Mail Answers
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
What is quality stage?
What is oci?
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
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Can you explain link buffering?
options available in sequence job to run,validate?
How can you write parallel routines in datastage PX?
Describe link sort?
How a source file is populated?
What are the various kinds of containers available in datastage?
What is the use of datastage designer?
What is the command line function to import and export the ds jobs?
What can we do with datastage director?
On which interface you will be working as a developer?
how to delete one row in target dataset
