Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 27001 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / ramarao
Hi Friends,
I think this possible by using source Qualifier ALSO.
The Senario is
Issue_id,Question,Answer
100,1,y
100,2,n
100,3,y
100,4,n
Target is issue_id,Answer1,Answer2,Answer3,Answer4
100, y,n,y,n
This can be Achived by using source Qualifier And joiners.
There is no need to use Normaliser.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Two default user groups created in the repository are____and_____.
what are Lookup caches options? Including persistent caches.
Can u access a repository created in previous version of Informatica?
Explain about hash partitioning?
What are the modules in Power Mart?
What is the difference between Data Warehousing and Data Mining?
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?
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 etl testing is different from database testing?
when will use SQL override in a lookup transformation?
What is cube grouping?
what is pmrep command?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
how would u estimate the size of Lookup transform data and index cache?
