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
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
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
What do think which one is the better joiner or look up?
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?
difference between shortcut and reusable transformation?
What is rank transformation in informatica
how i will stop my workflow after 10 errors
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
How to load last n records of file into target table - informatica
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
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?