srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Dec 7th, 2006

 

If the changes are applied to the look up, by using this performance will increase and reduce the usage of transformations.

Manisha

• Dec 14th, 2006

 

Dynamic Lookup is used when the table on which we are performing lookup is being written into. A very common example is when we lookup the Target table to deicde if a particular row is for Insert/update. It becomes dynamic as the cache is also updated with the table. A new Lookup Row Feild is created which marks the rows as 0 -update , 1- insert.

SRIRAM N

• May 9th, 2007

 

For relational lookups, you might want to configure the transformation to use a dynamic cache when the target table is also the lookup table. The PowerCenter Server builds the cache when it processes the first lookup request. It queries the cache based on the lookup condition for each row that passes into the transformation. When you use a dynamic cache, the PowerCenter Server updates the lookup cache as it passes rows to the target.