Interested to Buy Any Domain ? << Click Here >> for more details...
Diffrence between static and dynamic cache
- 2 Answers
- 6327 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva prasad
Static cache: Is readonly cache. We cannot insert or update
the records dynamically.
Dynamic Cache: It will refresh the changed data and
allocate a seperate buffer for that.Each time it will
identify the changed data rather than capture entire
data.we can insert or update the records dynamically.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sushma
If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
Which gives the more performance when compare to fixed width and delimited file ? and why?
tell me the push down optimization
How to load query faster,so that It will take less time to load?
What are the differences between oltp and olap?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the modules in Power Center
How to load the data from a flat file into the target where the source flat file name changes daily?
What is rank transformation in informatica
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
which is better perfomancewise lookup or joiner and why?can anyone give example?
Teradata 
