what is push down optimization ? what is its use and importance in data warehousing ?

soundararajan

• Nov 1st, 2015

I need brief explaination about
* Source side pushdown optimization
* Target side pushdown optimization
* Full pushdown optimization

Sreedhar Lokaray

• Nov 3rd, 2011

Pushdown Optimization is a new feature introduced from Informatica 8. To increase session performance, the integration service pushes transformation logic to the source or target database. Based on t...

Answer Question  Select Best Answer

sriinivas kasiboina

• Feb 15th, 2012

SCD Type 3 is used when it is necessary for datawarehouse to keep track of historical changes and when such changes will only for finite number of times.

sriram

• Sep 27th, 2011

Scd type3 is used for loading the current & most previous data into target

Answer Question  Select Best Answer