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

When we enable pushdown optimization technique, two options
will be enabled (use view,..). Can anyone tell me how these
two options will work ?
When do we need to go for pushdown optimization technique ?

Answer Posted / manojkumar

Thanks you so much parikhita.

Can you give me the exact two options(use view,..) which
will enabled when we select pod and how these options will
work?

When I select pod on source side, what about target insert
or update query ? will it be pushed to target db? Or only
select query will be pushed to source db ?

and when do we need to go for pushdown optimization
technique ? ofcourse it increses the performance. But at
what situation or circumstances we need to go for pod ?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the code page compatibility?

1034


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2074


Explain the different dimensions.

925


can we override a native sql query within informatica? Where do we do it? How do we do it?

1026


What are the main features of Oracle 8i with context to datawarehouse?

2070


On which transformations you created partitions in your project?

1281


How can we create index after completion of load process?

1084


server hot-ws270 is connect to Repository B. What does it mean?

2481


What you know about transaction control transformation?

953


How to load the data from people soft hrm to people soft erm using informatica?

964


What's the layout of parameter file (what does a parameter file contain?)?

2351


Name the different lookup cache(s)?

1173


Enlist few areas or real-time situations where informatica is required.

1041


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

997


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1971