swapna

• Feb 10th, 2006

 

When a workflow has multiple lookup tables use shered cache .

gazulas

 Profile Answers by gazulas Questions by gazulas

• Feb 11th, 2006

 

there r many ways to improve the mapping which has multiple lookups.

1) we can create an index for the lookup table if we have permissions(staging area).

2) divide the lookup mapping into two  (a) dedicate one for insert means: source - target,, these r new rows  . only the new rows will come to mapping and the process will be fast . (b) dedicate the second one to update : source=target,, these r existing rows. only the rows which exists allready will come into the mapping.

3)we can increase the chache size of the lookup.

Utkarsh

• Mar 25th, 2012

 

1) Create Indexes on look up tables.
2) Try to use static cache instead of Dynamic cache.
3) Use Pushdown Optimization.

jayapraveen

 Profile Answers by jayapraveen 

• Jun 21st, 2012

 

If the lookup source is same for all the lookups and if we are returning different columns for calculations then it is better to use unconnected lookup with expression instead of using connected lookup.