How to delete duplicate row using informatica?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,


I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  






Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,


what are the perameter and variable?

3 Answers   IBM,


suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,


,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


Explain the scenario which compels informatica server to reject files?

0 Answers  


i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,


Categories