How to Convert the columns into rows?

Answers were Sorted based on User's Feedback



How to Convert the columns into rows?..

Answer / sri

Using the Pivot we can convert the columns into rows

Is This Answer Correct ?    20 Yes 2 No

How to Convert the columns into rows?..

Answer / manu

By using 'ETERNAL PIVOT STAGE' we can do this

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Data Stage Interview Questions

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  


Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,


What is the purpose of pivot stage and types of containers in datastage

0 Answers  


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  


What modeling tool do you use?

6 Answers   HP,


Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,


how to call sequential generator in datastage?

1 Answers   IBM,


How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,


there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,


what is materialized view used datastage?

1 Answers   HSBC,


Define data aggregation?

0 Answers  


What are operators in datastage?

1 Answers  


Categories