Diffrence between static and dynamic cache

Question Posted / sunil.knl

2 Answers
6425 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Diffrence between static and dynamic cache..

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

Diffrence between static and dynamic cache..

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

Post New Answer

More Informatica Interview Questions

How to configure mapping in informatica?

0 Answers

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers Mphasis,

can we have to do changes in session property when we are dynamically generating target files?

3 Answers Wipro,

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers TCS,

What is the difference between a router and a filter transformation?

1 Answers TCS,

Is it possible to use a client with different version than that of its Informatica server?

0 Answers

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers TCS,

Explain how many types of dimensions are available in informatica?

0 Answers

What is the approximate size of data warehouse?

6 Answers Accenture, i3 Solutions,

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers HCL,

Please let me know how to make encryption and decryption with example?

0 Answers

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers iFlex, Morgan Stanley,

For more Informatica Interview Questions Click Here