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


how to through logic of informatica using the push down
optimization into oracle.

Answers were Sorted based on User's Feedback



how to through logic of informatica using the push down optimization into oracle...

Answer / varun4db

For source side we can push by overriding the query..so that
integration service pass the query to database... Please
correct me if am wrong..!!!

Is This Answer Correct ?    4 Yes 0 No

how to through logic of informatica using the push down optimization into oracle...

Answer / venubyna1

Asession configure for push down optimization to Increase
the session performance.
The I.S Analyze the mapping and T/r logic and determine T/r
logic it ll send to the source or Tager data base
I.S is convert the T/r logic into SQL then send to the data
base server
there r 3 types
1. Source side push down
2.Target side push down
3.fullside push down

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,


What is Java Transformation? what are the uses of it?

0 Answers   TCS,


Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,


What is a candidate key?

7 Answers   CTS,


what are the types of facts with Examples?

3 Answers  


A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  


What is persistent lookup cache?

0 Answers  


What is lookup change?

0 Answers  


Describe data concatenation?

0 Answers  


What are session parameters ? How do you set them?

0 Answers  


What are the tuning techniques you applied during your last project

0 Answers  


After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


Categories