How can we transform row to column?



How can we transform row to column?..

Answer / sailaja

using xmlpath function

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

In datastage can ve find the job based on source table name ??

1 Answers   TCS,


If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

3 Answers   Extech, Principal Finance,


Explain what are the various methods of getting incremental records or delta records from the source systems?

0 Answers  


What are the different methods of loading dimension tables?

0 Answers  


suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,


What needs to be done while starting the database?

0 Answers  


Explain some of modeling tools available in the market?

0 Answers  


After the generation of a report to whom we have to deploy or what we do after the completion of a report?

0 Answers  


What is meant by metadata in context of a data warehouse?

0 Answers  


Advantages of de normalized data?

2 Answers  


What is many-to-many dimensional model in datawarehousing ?

0 Answers  


how to calculate sum(sal) with out using aggregator satge

3 Answers   HSBC,


Categories