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
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the different types of repositories created using informatica?
What is data caches/ index caches?
How do you set a varible in incremental aggregation
How can you increase the performance in joiner transformation?
How can we use mapping variables in informatica? Where do we use them?
Where do we use mapping variables in informatica?
What is blocking transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the meaning of decode in informatica?
What are the tasks that source qualifier perform?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How many dimensions are there in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Is there any way to read the ms excel datas directly into informatica?