i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this
Answer Posted / ganesh yadav
using Normalizer Transformation we can convert the multiple
columns as multiple rows, multiple rows as multiple columns...
rows: 1 1 1 2 2 2
a b c a b c
answer
column wise
1 a b c
2 a b c
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Explain how to import oracle sequence into informatica?
How many types of sessions are there in informatica.please explain them?
Define mapping and session?
Please let me know how to make encryption and decryption with example?
What are the different types of olap? Give an example?
How do you load first and last records into target table?
What do you understand by a term domain?
What is the status code in stored procedure transformation?
What is the scenario which compels informatica server to reject files?
What is a joiner transformation?
What is expression transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the difference between Active and Passive transformation?
Explain load alternative records / rows into multiple targets - informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?