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


Please Help Members By Posting Answers For Below Questions

Have you have ever worked in unix environment and why it is useful in datastage?

645


What is use Array size in datastage

1300


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

2268


Different ways a project can be moved to production ?...example ….export-import and Version control.

1929


Highlight the main features of datastage?

613






Define ds designer?

766


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1131


Explain entity, attribute and relationship in datastage?

629


How complex jobs are implemented in datstage to improve performance?

589


What is the difference between odbc and drs stage?

637


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2839


Is the value of staging variable stored temporarily or permanently?

573


Differentiate between validated and Compiled in the Datastage?

639


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2741


AGGREGATOR default datatype

931