Results 1 to 2 of 2

Thread: Dynamic lookup cache is updation in informatica

  1. #1
    Senior Member
    Join Date
    Aug 2012
    Posts
    40,312

    Dynamic lookup cache is updation in informatica

    Please explain me when a dynamic look up cache is updated in informatica? Is it updated at the end or for each row?

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512
    Source row is compared against with the look up cache. If the source does not exist in the cache, then the row will be inserted into the cache. If the row exisits and there are any changes, then the row is updated in the cache. If the row exists and there are no changes, then nothing will happen in the cache.

    Cache is not udpated at the end. It is updated during the session run.

Similar Threads

  1. Dynamic source flat file name in informatica
    By amrutha in forum Data Warehouse
    Replies: 1
    Last Post: 12-10-2012, 08:42 AM
  2. Replies: 5
    Last Post: 10-09-2012, 10:01 AM
  3. Lookup cache interview question
    By anitha in forum Data Warehouse
    Replies: 0
    Last Post: 09-27-2012, 12:03 PM
  4. Dynamic lookup cache in informatica
    By james in forum Data Warehouse
    Replies: 1
    Last Post: 07-03-2012, 12:15 PM
  5. Cache using informatica transformations
    By vijay in forum Data Warehouse
    Replies: 1
    Last Post: 07-02-2012, 09:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •