Which type or t/s is used to convert rows into column &
column into rows
Answer Posted / sowjanya
Using BODS 3.2 or higher versions
To convert columns to Rows : PIVOT transform
To convert rows to coulums : REVERSE PIVOT transform
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
where is the cache (lookup, index) created and how can you see it.
what is the meant by Normalization and de-normalization?
What is a lookup table in etl?
Explain the key challenges that you face while performing etl testing.
Explain and compare etl & manual development?
can cubes contain measures ?
what is Forward,Reverse and Re_engineering?
Explain the difference between etl tool and olap tools?
Explain about hash partitioning?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Explain the use lookup tables and Aggregate tables?
What is lookup table in etl testing?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is a staging area? What is the purpose of a staging area?
Can there be sub steps of etl steps?