Data Warehousing Community Forum
February 09, 2012, 02:02:43 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: how can we perform the query optiization process ...  (Read 773 times)
mallireddy
DW Fresher
*

Reputation: +0/-1
Offline Offline

Posts: 3


View Profile
« on: July 05, 2010, 08:43:04 am »
in my mapping having lookup ..how can we optimize the query
Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: July 20, 2010, 09:52:46 pm »
Below are the Optimization techniques at Lookup TF level -

  • Use Lookup override
  • Multiple lookups can slow down the session. You might improve session performance by locating the largest lookup tables and tuning those lookup expressions.
  • If a mapping contains a Lookup transformation, you can optimize the lookup. Some of the things you can do to increase performance include caching the lookup table, optimizing the lookup condition, or indexing the lookup table
. 
Logged
Sipra
Founder

www.dwforum.net
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: