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

explain different levels in pushdown optimization with example?

Answer Posted / venubyna1

1. Source side push down
Integration service determine the T/r logic it ll send
as much as possible to source data base server

2.Target side push down
Integration service determine the T/r logic it ll send
as much as possible to targer data base server

3.fullside push down
Integration service determine the T/r logic it ll send
to source and target data base server

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load alternate records into different tables through mapping flow?

1821


Explain the different kinds of facts.

948


Enlist the differences between database and data warehouse.

1071


How do you load first and last records into target table?

1118


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1029


How can we remove the duplicates from flat file source?

971


How to create or import flat file definition in to the warehouse designer?

1039


explain abt ur project architecture?

2137


draw informatica architecture 8.6 ?

3838


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1240


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2206


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5715


How to load the data from people soft hrm to people soft erm using informatica?

963


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1045


What are the different types of repositories created using informatica?

1078