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 we create rank using datastage?what is the meaning of rank?
What is apt_config in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to add a new records into source?
options available in sequence job to run,validate?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the primary usages of datastage tool?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Difference between in process and inter process?
How to manage date conversion in Datastage?
What is the purpose of interprocessor stage in server jobs?
Highlight the main features of datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How can one find bugs in job sequence?