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 is work of PUSH DOWN option

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 am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  


What is DR strategy for Informatica project?

0 Answers  


What is an aggregator transformation?

0 Answers  


What are active and passive transformations?

0 Answers   Informatica,


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  


What are multi-group transformations?

0 Answers   Informatica,


Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,


source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,


How many cubes create from a single model?

1 Answers  


Differences between connected and unconnected lookup?

0 Answers  


What are the tuning techniques you applied during your last project

0 Answers  


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


Categories