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 can you generate reports in informatica?

1035


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10170


What is a predefined event?

1094


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1323


Explain the types of transformations?

1069


What do you mean incremental aggregation?

1077


What are the different ways to implement parallel processing in informatica?

1424


How can repository reports be accessed without sql or other transformations?

1220


can anyone explain me about retail domain project in informatica?

7948


Performance tuning in UNIX for informatica mappings?

2568


How can a transformation be made reusable?

1171


Explain why we use partitioning the session in informatica?

1094


Briefly define a session task?

1135


How to use pmcmd utility command?

1033


What is enterprise data warehousing?

1049