get me the resultant
input:- 1 x,y,z output:- 1 x
2 a,b 1 y
3 c 1 z
2 a
2 b
3 c

Answer Posted / j

Great!!!
It worked really well.
Thanks for the solution.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1320


What are the popular informatica products?

653


How to join three sources using joiner?

575


Explain the difference between a data warehouse and a data mart?

600


permutations of mapplet

2042






What is a pre-defined event and user-defined event?

580


State the limitations where we cannot use joiner in the mapping pipeline?

552


How do you manage the Parameter files while migrating your data from one environment to another environment?

555


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1711


How to load a Dimension ? and how to load a fact table?

957


How to extract sap data using informatica? What is abap? What are idocs?

560


Explain what transformation and how many are there in informatica?

489


what is diff b/t sorter t/r and agg have the option sorter property...

1748


Can informatica load heterogeneous targets from heterogeneous sources?

697


Implementation methodology

1265