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 is the use of code page?
What is an unconnected transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Define Pmrep command?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is rank transformation?
What are roles and groups and benefits of using them?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Please let me know how to make encryption and decryption with example?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How do you take back up of repository?
What is the sql query overwrite in source qualifier in informatica
What is meant by a domain?
How can you differentiate between powercenter and power map?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records