When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?

Answers were Sorted based on User's Feedback



When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

Answer / vinod saini

Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile

Is This Answer Correct ?    3 Yes 0 No

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

Answer / veera

When/Under what circumstances do we use dynamic and static
cache in connected
lookup?
When/Under what circumstances do we use static cache in
unconnected lookup?

Is This Answer Correct ?    1 Yes 2 No

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

Answer / bc

we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,


How to extract the informatica rejected data?

0 Answers  


can u any challenge your project?

0 Answers   HP,


what is $$$$?

0 Answers   TCS,


How to eliminate duplicates from flat file..what is the procedure

4 Answers  


How are indexes created after completing the load process?

0 Answers  


 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,


can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


What is a joiner transformation?

0 Answers  


What is the difference Between Mapping parameter and variable

3 Answers   Accenture,


What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,


what is difference between COM & DCOM?

1 Answers   Satyam,


Categories