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

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,


What do think which one is the better joiner or look up?

0 Answers  


How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,


difference between shortcut and reusable transformation?

2 Answers  






What is rank transformation in informatica

0 Answers   Informatica,


how i will stop my workflow after 10 errors

2 Answers   HP,


How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


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

0 Answers   Informatica,


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  


what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,


Categories