Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?


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

Post New Answer

More Informatica Interview Questions

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,


What is resilience time?

0 Answers  


How to load last n records of file into target table - informatica

0 Answers   Informatica,


What is operational data source (ODS)?

7 Answers  






What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,


which one is better performance wise joiner or look up

0 Answers   Informatica,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


what is curr val use for in sequence generator?

2 Answers   Emphasis,


what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,


Write the different tools in the workflow manager?

0 Answers  


Categories