Q: Different Types of Lookup Caches?
Ans:
Static Cache: Static Cache is only Read only Cache. when u create a lookup informatica bydefault it will cretaes a Static cache.it caches the lookup table and Value in cache for the rows that are entering into the lookup transformation. when the lookup condition is true, it will not Update the Cache until it it process the lookup transformation.
Dynamic Lookup: Unlike Static Cache,Dynamic Cache will Update the Cache if the lookup Condition is True. So Lookup Transformation Dynamically Inserts Data into the target table. This Cache is very Usefull To Avoid Duplicate Rows in target table.
Persistent Cache: We Can Save the lookup Cache Files and reuse them for the next time the informatica server process a lookup.
Recache from Database: if the persistent cache is not Synchronised with the lookup table, you can configure the lookup table to rebuild the lookup cache.
Shared Cache: you can Share the lookup cache between multiple transactions.you can share unnamed cache between Transformations in the Same mapping.
Ans:
Static Cache: Static Cache is only Read only Cache. when u create a lookup informatica bydefault it will cretaes a Static cache.it caches the lookup table and Value in cache for the rows that are entering into the lookup transformation. when the lookup condition is true, it will not Update the Cache until it it process the lookup transformation.
Dynamic Lookup: Unlike Static Cache,Dynamic Cache will Update the Cache if the lookup Condition is True. So Lookup Transformation Dynamically Inserts Data into the target table. This Cache is very Usefull To Avoid Duplicate Rows in target table.
Persistent Cache: We Can Save the lookup Cache Files and reuse them for the next time the informatica server process a lookup.
Recache from Database: if the persistent cache is not Synchronised with the lookup table, you can configure the lookup table to rebuild the lookup cache.
Shared Cache: you can Share the lookup cache between multiple transactions.you can share unnamed cache between Transformations in the Same mapping.
No comments:
Post a Comment