When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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?
How to extract the informatica rejected data?
can u any challenge your project?
what is $$$$?
How to eliminate duplicates from flat file..what is the procedure
How are indexes created after completing the load process?
 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?
can anyone explain me about sales project in informatica?
What is a joiner transformation?
What is the difference Between Mapping parameter and variable
What is an aggregator transformation? it is active why cant it be passive explain?
what is difference between COM & DCOM?