how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 25226 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 is transformation?
What is domain and gateway node?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the new features of informatica 9.x in developer level?
How is union transformation utilized?
How to do unit testing in informatica? How to load data in informatica ?
Whats there in global repository
Tell me about MD5 functions in informatica
How to extract sap data using informatica?
Explain sessions. Explain how batches are used to combine executions?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the main features of Oracle 8i with context to datawarehouse?
What is complex mapping?
What is a transaction control transformation?
