Diffrence between static and dynamic cache
- 2 Answers
- 5617 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 |
Without using Lookup & Sequence Generator, How to generate Sequence?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
How to send duplicates to one target and unique rows to one target?target is empty
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
update strategy transformation in informatica
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What is a node in Informatica?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
When will you use SQL override in a lookup transformation?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
how to return multiple columes through through un-connect lookup?
Teradata 
