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
Have you have ever worked in unix environment and why it is useful in datastage?
What is use Array size in datastage
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Different ways a project can be moved to production ?...example ….export-import and Version control.
Highlight the main features of datastage?
Define ds designer?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Explain entity, attribute and relationship in datastage?
How complex jobs are implemented in datstage to improve performance?
What is the difference between odbc and drs stage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Is the value of staging variable stored temporarily or permanently?
Differentiate between validated and Compiled in the Datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
AGGREGATOR default datatype