WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED
FOR INSERT , UPDATE OPRATION ?
Answer Posted / amedela chandra sekhar
when we enable dynamic cache in lookup one lookup port will be
created called NEW LOOKUP PORT.it is generate numeric values
in cache.
this will just synchronize data in lookup and target for
inserting and updating records.
chandumba2005@gmai.com
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Under which circumstances, informatica server creates reject files?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a sequence generator transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
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 sequence generator transformation in informatica?
Describe data concatenation?
What is intricate mapping?
How to convert multiple rows to single row (multiple columns) in informatica
What is standalone command task?
What are the different options available for update strategy?
What is meant by target load plan?
How can you increase the performance in joiner transformation?