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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is work of PUSH DOWN option

Question Posted / veeru

Answers were Sorted based on User's Feedback



what is work of PUSH DOWN option..

Answer / satya

In addition to Kapil's answer, You can have "push down"
optimization at source database or target database or Full
(Source and target). But before you enable this option you
keep the following things in mind

1. When you are processing long transaction at database
level , The objects will be lock and data base objects are
not available for other operations for long time.

2. It will inturn hampers the datbase concurrency and
increases the chance of "Dead locks" on database

Thanks : Satya

Is This Answer Correct ?    5 Yes 1 No

what is work of PUSH DOWN option..

Answer / kapil

The Pushdown Optimization Option improves performance by
enabling processing to be “pushed down” to a
relational database, maximizing fl exibility, minimizing
unnecessary data movement, and providing the optimal
performance for both data-intensive and process-intensive
transformations.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

How will u find weather dimension table is big in size of a fact table?

1 Answers  

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

In any project how many mappings they will use(minimum)?

1 Answers  

How do you remove duplicate records in informatica?

1 Answers  

How to create the source and target database connections in server manager?

0 Answers   Informatica,

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

what is the difference between repository & Intergration service

1 Answers  

Define joiner transformation?

0 Answers  

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

For more Informatica Interview Questions Click Here
Categories