how will you remove the duplicate records from flat file
without using sorter?

Answer Posted / sathish

put primary key to target it will reject duplicate rows

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the issues you have faced in your project? How did you overcome those issues?

1388


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

946


Have you worked with/created Parameter file

729


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1075


In which scenario did u used Mapping variable?

1028






What is an Integration service in Informatica?

136


How might one distinguish in the case of mapping is right or not without associating session?

87


What is the fact table?

92


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

626


What is persistent lookup cache?

71


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

9464


Can informatica load heterogeneous targets from heterogeneous sources?

92


explain one complex mapping with logic? sales project?

4562


How to call shell scripts from informatica?

95


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

101