Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

where actually the usage of push down optimization
happens...

Answer Posted / pradeep

Basically we use the push down optimization to reduce the load on the integration service.The integration service translate the business logic into sql query and it pushes to source & Target dbs.In this form we can reduce the load on integration.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the different lookup cache(s)?

1292


What do you mean by filter transformation?

1001


What are the new features of informatica 9.x at the developer level?

1105


Explain the features of connected and unconnected lookup.

973


State the limitations where we cannot use joiner in the mapping pipeline?

1105


Could you explain what is enterprise data warehouse?

1223


Define filter transformation?

1145


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2369


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2121


Enterprise data warehouse your projects phase by phase explain?

1962


Explain sessions and how many types of sessions are there?

1056


What is a stored procedure transformation?

1109


What is the Process to creating lookup transformation in informatica

1088


What is a mapplet/worklet in informatica?

1242


In informatica workflow manager, how many repositories can be created?

1435