Interested to Buy Any Domain ? << Click Here >> for more details...
where actually the usage of push down optimization
happens...
- 2 Answers
- 5515 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pradeep
Basically we use the push down optimization to reduce the load on the integration service.The integration service translate the business logic into sql query and it pushes to source & Target dbs.In this form we can reduce the load on integration.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the use of an aggregator cache file?
Filter transformation in the condition one of the data is NULL would the record be dropped.
which is better perfomancewise lookup or joiner and why?can anyone give example?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
If informatica has its scheduler why using third party scheduler?
What is powercenter on grid?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
what is the drillup & drill down?and use of the drill up and drill down?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What are the differences between source qualifier and joiner transformation?
how you will maintain version?
what is plsql table?
Teradata 
