Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between static and dynamic
- 4 Answers
- 25328 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
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
What is workflow? What are the components of workflow manager?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the restrictions of union transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain the tuning lookup transformation - informatica
What is native users?
What is Cognos script editor?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is meant by target load plan?
What is Session and Batches?
What is confirmed fact in dataware housing?
How can a transformation be made reusable?
What is resilience time?
What is deployment group?
How would you join a node to the already existing domain?
