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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1602


What are the types of caches in lookup?

590


What is joiner change?

697


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6766


What are junk dimensions?

643






Can you generate sequence numbers without using the sequence generator transformation?

609


What is joiner transformation in informatica?

640


What is parallel processing in informatica?

1046


Explain lookup transformation is active in informatica

675


What is the need for an etl tool?

651


What are the new features of informatica 9.x in developer level?

578


Can informatica load heterogeneous targets from heterogeneous sources?

709


What is workflow monitor?

613


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

603


How do you use reject loader.

2080