slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
push down optimization PowerPoint Presentation
Download Presentation
push down optimization

Loading in 2 Seconds...

  share
play fullscreen
1 / 8
Download Presentation

push down optimization - PowerPoint PPT Presentation

shreeja
17 Views
Download Presentation

push down optimization

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Informatica Push Down optimization http://www.datawaretools.in/

  2. 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.

  3. Types of Push Down Optimization •Source-side push down optimization •Target-side push down optimization •Full push down optimization

  4. 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

  5. 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

  6. 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

  7. Working with Databases • IBM DB2 • Microsoft SQL Server • Netezza • Oracle • Sybase ASE • Teradata • Databases that use ODBC drivers

  8. Communication • NO.84/8 Venkatrathinam Main street , LB road , Adyar , chennai-600020 • Contact –9566293201 • http://www.datawaretools.in/