srinuvas.j

• Dec 20th, 2006

 

Static cache : First data is loaded into informatica buffer or cache memory ,If you update or new inserted data  comes into inf buffer and compare new inserted or updated records pass new modified data into targets.hire data is passed each and every transformation.

it is used connected and un-connected lookup transformations.

dynamic cache directly loaded into target table i.e,data directly compared into lookup table load into target.

un -connected lookup table it is not possible

Sravan Kumar

• Dec 20th, 2006

 

Mainly we have two caches in Lookup transfermations.

1.Static cache.2.Dynamic cache

We can use static cache as connected and Unconnected But dynamic cache is connected only.

1.By using Connected Dynamic Cache We can look up the data in the target table and compare the Source records with the target records and inserts or updates the records during the session run.

2.By default lookup cache remains static and it doesnot changes(neither Inserts nor Update) during the session run.

Sravan Kumar

Abhijit

• Jan 26th, 2007

 

Hi,In Static Cache the CACHE ON THE LOOKUP TABLE is built only once - when the 1st row enters the lookup for a comparision.During the whole session the cache stays as it was, hence the name static.In contrary, the dynamic cache keeps on changing(if there is any change) during the session run itself. Rows are inserted and updated ( depending on the logic and incoming data) in the cache itself. One, then has to synchronize the data between the lookup cache and the target table ( Dynamic caches are used for the purpose where the lookup is on the target itself for eg:loading a dimension). For this sync..ing we use the Newlookupport value in the subsequent update strategy transformations.Cheers Abhijit