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 do you schedule or monitoring the job?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the areas of application?
Is the value of staging variable stored temporarily or permanently?
What are the primary usages of datastage tool?
Name the different types of Lookups in Datastage?
What is orabulk stage?
Distinguish between informatica & datastage. Which one would you choose and why?
Where do you see different stages in the designer?
What is staging variable?
How do you run datastage job from the command line?
What is the flow of loading data into fact & dimensional tables?
What is a folder? Difference types of stages?
How you Implemented SCD Type 1 & Type 2 in your project?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?