without dynamic lookup transformation how to insert new
rows and update existing rows?
Answer Posted / bj
With out lookup and update st. transformation we can still
insert new and update data at session level.
in session at the time giving target table connect bottom u
find insert and update just check that box.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How many ways a relational source definition can be updated and what are they?
What is target load order?
Whats there in global repository
What is event and what are the tasks related to it?
Differentiate between source qualifier and filter transformation?
How are indexes created after completing the load process?
How many numbers of sessions can one group in batches?
What is difference between a gateway node and worker node?
What is complex mapping?
While migrating the data from one environment to another environment how would you manage the connections?
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
How can we remove the duplicates from flat file source?
What is the need for an etl tool?
Explain how many types of dimensions are available in informatica?
Differentiate between joiner and lookup transformation?