How to Convert the columns into rows?
Answers were Sorted based on User's Feedback
Answer / sri
Using the Pivot we can convert the columns into rows
| Is This Answer Correct ? | 20 Yes | 2 No |
How do you design PX Routines ?
Differentiate between datastage and datastage tx?
How to display errors in datastage?
what is the definitions for Datawarehose and Datamart?
What is a quality stage in datastage tool?
whats relation between configuration file and datasets?
how many stages are there in Datastage... Please clarify mee??
How to implement complex jobs in data stage?
on how many columns we can perform aggregation in the Aggregator stage?
How many input links can you give to a Transformer stage?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00