Which type or t/s is used to convert rows into column &
column into rows
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
how do u set partition points in the mapping?
Explain me ETL project architecture in Detail?
Is hadoop a etl tool?
how to load the data to fact table?
what is the difference steps for data modeling?
how do u extract data from different data sources explain with an example?
What is abap? What are idocs?
Give the benefits of data integration suite?
How to delete data which is not in source table?
Compare ETL & Manual development?
dimension object created in oracle can be imported in designer?how?
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 are three tier systems in etl?
What are snapshots?
In Which Transformation We Can Use Having Clause In Informatica?