WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED
FOR INSERT , UPDATE OPRATION ?
- 4 Answers
- 12705 Views
- Oracle, I also Faced
- E-Mail Answers
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 |
How the Informatica Server reads perameter file?
What is a connected transformation?
Design a mapping to load a target table with the following values from the above source?
What is a joiner transformation?
sample mappings for scd1,scd2 and scd3
How Union Transformation is an Active Trans?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the diffrences between joiner transformation and source qualifier transformation?
How will you combine 3 different sources with a single source?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
What is the difference between SOURCE and TARGET BASED COMMITS?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
Teradata 
