Results 1 to 2 of 2

Thread: Dynamic lookup cache is updation in informatica

  1. 12-09-2012, 01:16 PM #1
    amrutha
    amrutha is offline
    Senior Member
    Join Date
    Aug 2012
    Posts
    114

    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?
    Reply With Quote Reply With Quote
  2. 12-10-2012, 08:19 AM #2
    vijay
    vijay is offline
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    490
    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.
    Reply With Quote Reply With Quote
« Differences between RDBMS and Hadoop/ Hive | From starschema ETL to Datawarehouse »

Similar Threads

  1. Dynamic source flat file name in informatica
    By amrutha in forum Data Warehouse
    Replies: 1
    Last Post: 12-10-2012, 07:42 AM
  2. How to handle dynamic change in source file name - informatica
    By vijay in forum Data Warehouse
    Replies: 5
    Last Post: 10-09-2012, 09:01 AM
  3. Lookup cache interview question
    By anitha in forum Data Warehouse
    Replies: 0
    Last Post: 09-27-2012, 11:03 AM
  4. Dynamic lookup cache in informatica
    By james in forum Data Warehouse
    Replies: 1
    Last Post: 07-03-2012, 11:15 AM
  5. Cache using informatica transformations
    By vijay in forum Data Warehouse
    Replies: 1
    Last Post: 07-02-2012, 08: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
  •  

Forum Rules