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


what are the limitations of pushdown optimization
technique ?

Advance thanks

Answers were Sorted based on User's Feedback



what are the limitations of pushdown optimization technique ? Advance thanks..

Answer / nitin

1) we can not perform PDO if we are using variable ports and informatica inbuilt functions.
2) If we have source and target on the different schema we can not go for full PDO, in this case either we have to go for source PDO or Target PDO.

Is This Answer Correct ?    7 Yes 0 No

what are the limitations of pushdown optimization technique ? Advance thanks..

Answer / rao

1)We can not apply push down optimization if mapping contain
aggregate transofrmation.

2)When we implement p.optimization ,the integration services
send logic to databases.because of this wa can not capture the
rejected records in reject file.

Is This Answer Correct ?    7 Yes 14 No

what are the limitations of pushdown optimization technique ? Advance thanks..

Answer / chandu

we can't implement for aggregator tranformation
we cant implement for master source in joiner transformation

Is This Answer Correct ?    7 Yes 18 No

Post New Answer

More Informatica Interview Questions

What are the types of lookup transformation?

0 Answers   Informatica,


what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


Explain the flow of data in Iinformatica?

1 Answers  


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

0 Answers  


what is surrogate id ?

3 Answers   IBM,


How many input parameters can exist in an unconnected lookup?

0 Answers  


Describe an informatica powercenter?

0 Answers  


where to store informatica rejected data?

0 Answers  


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


what is sql override?what is the use of it?

4 Answers   Sonata,


what is left outer join?

3 Answers   L&T,


how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,


Categories