Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 27602 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
What are the ETL Testing Operations?
what is different between sequential batch and concurrent batch and which is recommended and why?
What is fact? What are the types of facts?
What do you understand by active and passive transformations?
What are the different Lookup methods used in Informatica?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
how do u identify the changed records in operational data?
Can u access a repository created in previous version of Informatica?
Give the benefits of data integration suite?
What are three tier systems in etl?
where are the log files generally stored.Can you change the path of the file.what can the path be?
what is the difference between cardinality and Nullability?
What is data cleaning?
what are the concerns of OLTP and DSS systems?
