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
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
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 a mapplet/worklet in informatica?
How many transformations can be used in mapplets.
What is the difference between writing a joiner query in ANSI style and THETA style?
What is sorter transformation?
What are the measure objects?
Can we create a Integration service without a Repository service and vice versa?
What is target designer and target load order?
Explain the difference between a data warehouse and a data mart?
How might one distinguish in the case of mapping is right or not without associating session?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is difference between a gateway node and worker node?