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
What is a shortcut and copy in Informatica and how two are different with each other?
How do you load only null records into target?
what is informatica metadata?
Differences between version 7.x and 8.x.
Explain pushdown optimization $pushdownconfig parameter - informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the need for an etl tool?
How can you increase the performance in joiner transformation?
Write the advantages of partitioning a session?
Differentiate between source qualifier and filter transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the difference between informatica 7.0 and 8.0?
What is domain in terms of informatica?
What are the new features of informatica 9.x in developer level?
Please let me know how to make encryption and decryption with example?