Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 26997 Views
- Infosys, I also Faced
- E-Mail Answers
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
Is hadoop a etl tool?
Give the benefits of data integration suite?
what is session partitioning?
what are the production issues in datastage?
What are the different etl testing categories as per their function?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What is the difference between round-robin partitioning and hash partitioning?
What is a mapping?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
how to load the data to fact table?
What are the steps involved in etl process?
Define slowly changing dimensions (SCD)?
What are the three tiers in etl?
What is cube grouping?
