How do you remove duplicate records in informatica? And how many ways are there to do it?


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

Post New Answer

More Informatica Interview Questions

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,


Explain the code page compatibility?

0 Answers  


Can we use parameters of parameter file in presession command

1 Answers   Wipro,


Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,


In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,






Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  


What are the circumstances that infromatica server results an unreciverable session?

1 Answers  


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


How to recover the standalone session?

2 Answers  


can we use bulk loading when we use look in mapping

1 Answers   TCS,


How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,


What is a command that used to run a batch?

4 Answers  


Categories