Answered Questions

  • What r the types of lookup caches?

    Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...

    adhoc

    • Sep 13th, 2011

    There are 2 important caches. 1. Static : By default integration service chooses statyic cache.It is read only cache . when you first query the lookup table, it caches the table. whenever a row com...

    Mattock

    • Sep 7th, 2011

    Caches are of following types:
    1. Static Cache
    2. Dynamic Cache
    3. Persistent Cache
    4. Non-persistent Cache
    5. Shared Cache
    6. Un-shared Cache

    More types to follow...:-)