By using 'ETERNAL PIVOT STAGE' we can do this

How to Convert the columns into rows?

Question Posted / manu

Answer Posted / manu

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Give an idea of system variables.

961

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2819

What are stage variables?

1136

Can you highlight the main features of ibm infosphere information server?

1044

What is job control?

1031

What is the flow of loading data into fact & dimensional tables?

1011

Highlight the main features of datastage?

1086

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

1679

Can you implement SCD2 using join, transformer and funnel stage?

1495

What are the different plug-ins stages used in your projects?

1026

On which interface you will be working as a developer?

985

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3261

AGGREGATOR default datatype

1385

Difference between sequential file and data set?

1132

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2002