Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 26942 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
What is the difference between Data Warehousing and Data Mining?
How to increase performance without changing anything in mapping.( In prod)
What are your responsibilities as an etl tester?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
Do we need an etl tool?
what are the concerns of OLTP and DSS systems?
Explain what are the various etl tools in the market?
When do we analyze the tables? How do we do it?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is Data Vault???
how many steps are there in etl process?
what is pmrep command?
what is the main role of FI on business
What are the differences between sql override and update override?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
