Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between static and dynamic
- 4 Answers
- 25554 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 dimensional table?
What are the data movement modes in informatica?
What are the measure objects?
What is the benefit of partitioning a session?
Whats there in global repository
What is sorter transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is joiner transformation in informatica?
Parameter and variable differences
Explian the Process of deployment groups in informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is expression transformation?
Explain sessions and how many types of sessions are there?
