WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED
FOR INSERT , UPDATE OPRATION ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bsgsr
u mean inserting and updating the source records into the
cache. then the answer shud be insert else update which
lies below dynamic lookup port.
| Is This Answer Correct ? | 1 Yes | 4 No |
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
Is it possible to have "5 source & 5 Target" in single mapping?
what are the real time problems generally come up while doing or running mapping or any transformation?
Differentiate between sessions and batches?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
WHat all joins are there in Source Qualifier?
what is curr val use for in sequence generator?
What is the difference between a connected look up and unconnected lookup?
Can we update the data in flat file using update strategy?
What is staging area?
What are the features of complex mapping?
What are the rank caches?