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
How can one find bugs in job sequence?
Could anyone give brief explanation bout datastage admin
How to find value from a column in a dataset?
Which algorithm you used for your hashfile?
How one source columns or rows to be loaded in to two different tables?
Name the command line functions to import and export the DS jobs?
What are the types of containers and how to create them?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Define Job control?
How the ipc stage work?
Have you have ever worked in unix environment and why it is useful in datastage?