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

Explain in detail about scd type 1 through mapping.

0 Answers  


How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,


Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,


What is a command that used to run a batch?

2 Answers  


What are the basic needs to join two sources in a source qualifier?

3 Answers  


How is Data Models Used in Practice?

1 Answers  


Informatica settings are available in which file?

0 Answers   Informatica,


Is it possible to revert a global repository to local one and why?

0 Answers  


what are the types of Data warehousing ?

1 Answers  


What is the difference between Bulk Load and Normal Load

3 Answers   TCS,


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,


Categories