i have source like
X1 10
X2 20
X1 30
X2 40
i want target as
X1 X2
10 20
30 40 in informatica
Answer Posted / raji
Well,As of my knowledge.....
first u have to take eliminet the duplicates.....like
SRC---->SQ--->AGG---->TGT
in aggr t/f give the group by for both ports...
after this step just use a normalizer t/f to convert these
rows in to columns...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
What is informatica powercenter repository?
What is the difference between a connected look up and unconnected lookup?
Explain the code page compatibility?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are mapplets?
Explain the use of aggregator cache file?
waht type of interface is used for testing the data in informatica
In informatica workflow manager, how many repositories can be created?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is informatica? Why do we need it?
What is olap (on-line analytical processing?
What are Dimensional table?
What is domain in terms of informatica?
How to load the data from people soft hrm to people soft erm using informatica?