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


One of the optimizing technique to improve the session
performance is push down optimization,by using push down
optimization we push as much as transformation logic to
source/target database,but this degrades the d/b
performance,how to overcome this?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  


i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,


What is workflow? What are the components of workflow manager?

0 Answers  


Explain about cumulative Sum or moving sum?

0 Answers   Informatica,


What are the data movement modes in informatcia?

1 Answers  


Difference between Data and Index Caches?

0 Answers   Informatica,


what is diff between grep and find

3 Answers   IBM, iFlex,


WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,


how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,


What is lookup transformation?

0 Answers  


How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,


There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  


Categories