Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 27607 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 use of server manager?
How many types of transformations supported by sorted input?
what are the production issues in datastage?
Can u access a repository created in previous version of Informatica?
how many steps are there in etl process?
Mention few test cases and explain them?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
what is an ETL or ETT? And what are the different types?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are the different etl testing categories as per their function?
what are the concerns of OLTP and DSS systems?
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 etl process?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
