Interested to Buy Any Domain ? << Click Here >> for more details...
how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 27953 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / krishna
hi neetu,
i hope you were a bit wrong.
static cache is also used to check whether row exists or
not.....
well krishna for your question on dynamic cache..
static cache is one in which data when changed in the
target table cannot be incorporated in the look up on the
fly.
when you use a dynamic cache any changes to the target
table gets reflected in the lookup even if the record is
being inserted or updated in the same mapping run priorly
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What does role playing dimension mean?
How can you differentiate between powercenter and power map?
How to create Target definition for flat files?
What is a transaction control transformation?
How do you set a varible in incremental aggregation
How to generate or load values in to the target table based on a column value using informatica etl tool.
Where is metadata stored?
What happens when a session fails and you click on recover?
explain abt ur project architecture?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How does the aggregator transformation handle null values?
What do think which one is the better joiner or look up?
Explain direct and indirect flat file loading (source file type) - informatica
What is the difference between a connected look up and unconnected lookup?
What are the components of Informatica? And what is the purpose of each?
