What is Target Update Override? What is the Use ?
Answer Posted / himanshu
The answer #1 is correct but I also think that this can be
used for updating when target is flat file too
| Is This Answer Correct ? | 0 Yes | 17 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the use of transformation?
What is transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Why union transformation is an active transformation?
Can we create a Integration service without a Repository service and vice versa?
Enlist few areas or real-time situations where informatica is required.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Could you explain what is enterprise data warehouse?
What are the modules in Power Center
design of staging area?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
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 is the session task and command task?