Sunday, November 9, 2008

1) MY PEER (SUHAS) GUIDE LINES on Push Down Optimization

Hi all,

From informatica 8.x there is special license for push down optimization , which effectively helps in reducing performance issues usually there are three types of push down optimization
source ,target and transformation .If source push optimization is selected the informatica server uses all the source database resources for effectively loading the data where as target push down optimization the informatica server uses the target resources which reduces the burden on the informatica server.

The is set in the session in the properties tab.

No comments: