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

What is lookup change?

624


What is the difference between informatics 7x and 8x and what is latest version?

549


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

601


What will be the approach?

584


Enlist the various types of transformations.

562






What is the benefit of partitioning a session?

635


What is source qualifier transformation in informatica?

579


What is update strategy transform?

580


What do you mean by filter transformation?

557


Which means the first record should come as last record and last record should come as first record and load into the target file?

614


What is rank transformation in informatica

693


What is persistent lookup cache?

607


What is meant by lookup transformation?

618


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

565


What is the advantage of informatica?

650