How to delete duplicate record in Informatica?

Answer Posted / mayuri

Select ditinct in properties of source qualifier
transformation.

Is This Answer Correct ?    21 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why update strategy and union transformations are active?

589


What are the main features of Oracle 8i with context to datawarehouse?

1678


What is domain and gateway node?

690


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

603


Explain pmcmd command usage in informatica

699






What is sq transformation?

658


What is a passive transformation?

638


Performance tuning in UNIX for informatica mappings?

2137


Partition, what happens if the specified key range is shorter and longer

2029


What is the difference between STOP and ABORT options in Workflow Monitor?

691


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4774


Explain about cumulative Sum or moving sum?

618


I have a flat file, want to reverse the contents of the flat file

686


Explain how many types of dimensions are available in informatica?

590


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2423