Interested to Buy Any Domain ? << Click Here >> for more details...
where actually the usage of push down optimization
happens...
- 2 Answers
- 5511 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
How to create a non-reusable instance of reusable transformations?
Tell me about Propagate functions in informatica
How does the aggregator transformation handle null values?
What are the tuning techniques you applied during your last project
How can we store previous session logs?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Clarify the aggregator change?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Briefly describe lookup transformation?
What are the differences between source qualifier and joiner transformation?
What all join we can perform in LOOKUP transformation?
What is the benefit of session partitioning?
What is informatica worklet?
How to do unit testing in informatica?
What are the features of complex mapping?
