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
Write the unconnected lookup syntax?
What all are steps in up gradation of Informatica server?
What is a predefined event?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the popular informatica products?
wat are deployement groups in informatica, how it will be used for developers
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the tasks that can be performed using sq?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is rank index in rank transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How would you join a node to the already existing domain?
What is informatica? Why do we need it?
Describe expression transformation?