what is the difference between static and dynamic
Answer Posted / nagaraju bhatraju
Uncached lookup: The informatica server doesnot build a
cache for temporary starage of data. Wenever it need to
refer to the look up table, it scans the source directly.
Dynamic Cache: The informaatica server builds a cache of
the source wen the workflow runs for the first time and it
updates the cache records dynamically after each row it
loads to the target. Means, if a target row gets updated,
the dynamic cache also gets updated automatically after
that particular row comitted in the target.
or
Dynamic cache - can be configured as connected lookup only.
It does not support lookup on flat file. Can have only
equality operator in lookup condition.
Static cache - can be configured as connected as well as
unconnected lookup. Supports lookup on flatfile. Can have
any relational operator in lookup condition.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
In development project what is the process to follow for an etl developer from day1
How to handle decimal places while importing a flatfile into informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is meant by LDAP users?
What is informatica metadata and where is it stored?
How we can create indexes after completing the load process?
What is the use of code page?
what is SDLC way of code development?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the scenario which compels informatica server to reject files?
How do you manage the Parameter files while migrating your data from one environment to another environment?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the types of schemas we have in data warehouse.
What is the session task and command task?
Do you find any difficulty while working with flat files as source and target?