How we can convert rows to columns in datastage?
Answer Posted / manohar palla
I am going to use tranformer and funnel stages to implement the
pivot functionality.
name ph1 ph2---> tranformer--->tf1 name ph1
| funnel---->o/p
|____>tf2 name ph2
tf1 and tf2 are the TWO links from transfomer..
in tf1 we have the name and ph1 where in tf2 name and ph2.
In funnel stage i am going to club the two links and send it
to o/p.
Thanks :)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is meta stage?
how to implement scd2 in datastage 7.5 with lookup stage
What is the difference between hashfile and sequential file?
What are the different types of lookups in datastage?
Name the command line functions to import and export the DS jobs?
Notification Activity
What a datastage macro?
Differentiate between validated and Compiled in the Datastage?
CHANGE CAPTURE
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Have you have ever worked in unix environment and why it is useful in datastage?
what is repositery?
Give an idea of system variables.
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How can we improve the performance in datastage?