Interested to Buy Any Domain ? << Click Here >> for more details...
where actually the usage of push down optimization
happens...
- 2 Answers
- 5500 Views
- I also Faced
- E-Mail Answers
Answer Posted / krish
One can push transformation logic to the source or target
database using pushdown optimization. The Integration
Service translates the transformation logic into SQL queries
and sends the SQL queries to the source or the target
database which executes the SQL queries to process the
transformations. The amount of transformation logic one can
push to the database depends on the database, transformation
logic, and mapping and session configuration. The
Integration Service analyzes the transformation logic it can
push to the database and executes the SQL statement
generated against the source or target tables, and it
processes any transformation logic that it cannot push to
the databas
there are some limitations to it like if we are using
variable port we can't do pushdown.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
What is blocking transformation?
Where can we find the throughput option in informatica?
What is meant by query override?
How to partition the Session?
Can we create two repositories on same database instance in oracle?
Which transformation is needed while using the Cobol sources as source definitions?
What is informatica? Why do we need it?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to generate sequence numbers?
How to join three sources using joiner?
What is the need of etl tools?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the new features of informatica 9.x at the developer level?
wf dont have integration severances how you can run?
