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 are the Methods For Creating Reusable Transformations?

647


How do you manage the Parameter files while migrating your data from one environment to another environment?

540


what is the -ve test case in your project.

1848


what is the Default Source Option For Update Strategy Transformation?

753


What are the types of caches in lookup?

564






what is degenerated dimension?

3149


What are the components of Informatica? And what is the purpose of each?

615


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1470


how we can load rejected record's at run time?(not through bad files)

1906


On which transformations you created partitions in your project?

759


tell me the rules and responsblites in our project(my project is development)

1493


Plz can any one say me how to get the informatica certification materials and dumps

1594


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1731


Write the unconnected lookup syntax?

654


Why do you use Mapping Parameter and mapping variable?

1280