we have three columns and two rows.
col1 col2 col3
a b c
want to change into 2 columns and 3 rows ,how?
col1 a
col2 b
col3 c
which transformation u'll use and how?
Answer Posted / sbvprasad
by using normalizer T/r u can do the above logic
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the components of Informatica? And what is the purpose of each?
COM components can be used in Informatica
Mention few advantages of router transformation over filter transformation.
What do you mean by enterprise data warehousing?
How to load the data from a flat file into the target where the source flat file name changes daily?
Can we create multiple integration service on single repository?
How do you convert single row from source into three rows into target?
Define mapplet?
State the differences between sql override and lookup override?
What are data-driven sessions?
What are mapplets?
What is enterprise data warehousing?
What is the sequence generator transformation in informatica?
Tell me about MD5 functions in informatica
Define Pmrep command?