what is lookup ?7 12308
what is the flow?1 6194
In update strategy target table or flat file which gives more performance ? why?7 21601
Why touse stored procedure in ETL Application?2 9359
What is critical mapping?2 9145
How to view and Generate Metadata Reports?1 6174
what is the gap analysis?1 7528
How to recover sessions in concurrent batches?3 13103
what are the different types of transformation available in informatica and what are the mostly used ?
What is a transaction control transformation?
What is the need for an etl tool?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the difference between informatics 7x and 8x and what is latest version?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the difference between router and filter?
Plz can any one say me how to get the informatica certification materials and dumps
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
where to store informatica rejected data? How to extract the informatica rejected data?
what is informatica metadata?
What is different between the data warehouse and data mart?
How to create Target definition for flat files?
How might you approve all mappings in the archive all the while?
What is union transformation?