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


Please Help Members By Posting Answers For Below Questions

tell me 5 session failure in real time how can you solve that in your project?

1627


What are mapplets?

814


Name the different lookup cache(s)?

699


How to call shell scripts from informatica?

570


In informatics server which files are created during the session rums?

628






is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

617


what is degenerated dimension?

3144


What are the steps involved in the migration from older version to newer version of Informatica Server?

1572


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1525


Explain joiner transformation in informatica

664


COM components can be used in Informatica

1867


which one is better performance wise joiner or look up

620


What is fact table? Explain the different kinds of facts.

610


How to load data in informatica ?

565


Mention few power centre client applications with their basic purpose?

532