how can we do performance tuning using query hints(source bottleneck)??? in informatica tool
Printable View
how can we do performance tuning using query hints(source bottleneck)??? in informatica tool
Hi Nagu,
You can add hints only where you can modify the SQL statements . i,e in Source Qualifier and Lookups. We add an hint when we want to do Cost Based Optimization. (CBO)
If there is a source bottleneck , we can modify the Source Qualifier to add hints. Usually it is a good practice to bring all the data into Informatica with SQ and perform the filter thereafter, instead of trying to filter in SQ itself.
There are many tricks to solve the bottleneck. I can give more input based on what is excatly the issue and how many sources and volume of data u r dealing with.
Hope this helps!