Interested to Buy Any Domain ? << Click Here >> for more details...
where actually the usage of push down optimization
happens...
- 2 Answers
- 5610 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 code page?
How do you join more than 3 flat files in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is a command that used to run a batch?
What is a filter transformation?
What is dynamic cache?
update strategy transformation in informatica
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
What is query panel?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
What are the limitations of joiner transformation?
what is the process of target load planing?
Teradata 
