Interested to Buy Any Domain ? << Click Here >> for more details...
Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 29755 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 reporting tools and difference between them?
what is Forward,Reverse and Re_engineering?
what is an ETL or ETT? And what are the different types?
Compare etl & elt?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What is lookup table in etl testing?
what is the use of server?
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?
what is the difference steps for data modeling?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
How to increase performance without changing anything in mapping.( In prod)
Mention few test cases and explain them?
What is a materialized view log?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
list and discuss two approaches for updation of target table in Informatica and how they are different.
