How many ways are there to do 'remove duplicate records in informatica'?


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

Post New Answer

More Informatica Interview Questions

What are the options in the target session of update strategy transsformatioin?

2 Answers  


get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,


Insert else update option in which situation we will use

4 Answers   HCL,


When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  


what is threshold error in informatica?

1 Answers   TCS, Wipro,






What is the benefit of partitioning a session?

0 Answers  


Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  


Differentiate between reusable transformation and mapplet.

0 Answers  


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


How mapping parameter and variable works

1 Answers  


how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,


Categories