Informatica Push Down optimization http://www.datawaretools.in/
What is Push Down Optimization • It allows developers to balance data transformation load among servers • Integration service translates the transformation logic into SQL queries and then send to target database.
Types of Push Down Optimization •Source-side push down optimization •Target-side push down optimization •Full push down optimization
Source-side push down optimization • Integration service transformation logic as possible to the source database . • Integration services analyses the mapping from the source to the target for downstream . • It executes the SELECT statement based upon the transformation logic and push to the database. pushes
Target-side push down optimization • Integration transformation logic to the target database. • Integration service analyses the mapping from source to target to reach upstream transformation. • It generates INSERT, DELETE or UPDATE statement based upon the transformation logic. service pushes
Full push down optimization • It push all transformation logic to the target database. • It can perform both source-side as well as target-side push down optimization. • When you generate a long transaction it will have various steps
Working with Databases • IBM DB2 • Microsoft SQL Server • Netezza • Oracle • Sybase ASE • Teradata • Databases that use ODBC drivers
Communication • NO.84/8 Venkatrathinam Main street , LB road , Adyar , chennai-600020 • Contact –9566293201 • http://www.datawaretools.in/