how u know when to use a static cache and dynamic cache in
lookup transformation.
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 are the tasks that can be performed using sq?
What is the difference between a repository server and a powerhouse?
What are the guidelines to be followed while using union transformation?
Define filter transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Repository user profiles
What is source qualifier transformation in informatica?
What is the Rank index port in Rank transformation?
what is $$$$?
Explain target update override in informatica
What is enterprise data warehousing?
Explain incremental aggregation in informatica
Make a note of the quantity vaults made in informatica?
Differentiate between router and filter transformation?
Explain joiner transformation in informatica