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

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

Question Posted / psrreddy99

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 sorter transformation?

0 Answers  

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

Can i create a lookup table without cache.

7 Answers   iGate,

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

How to load relational source into file target?

3 Answers   IBM,

Why we use stored procedure transformation?

4 Answers  

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

How to elaborate powercenter integration service?

0 Answers  

When will you use SQL override in a lookup transformation?

1 Answers  

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

For more Informatica Interview Questions Click Here
Categories