Interested to Buy Any Domain ? << Click Here >> for more details...
When we enable pushdown optimization technique, two options
will be enabled (use view,..). Can anyone tell me how these
two options will work ?
When do we need to go for pushdown optimization technique ?
- 3 Answers
- 17473 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / priyank
Hi,
For Pushdown optimization, we use
1. Temporary View for the below scenarios:
a. When the SQ or look up t/f contain a SQL override.
b. When the look up t/f is used with Filter t/f.
c. When an unconnected look up is used.
2. Temporary Sequence is used for the below scenario:
a. When a Sequence generator t.f is used in the mapping.
When Source side PDO is selected, the IS traverses from
Source side to the Target side till it comes across a
transformation whose logic cannot be pushed to the
database. If the logic for all the transformations can be
pushed to the database, still the target update override
query will be executed on the target database as logic of
transformations are pushed to the database whcih includes
the SQ query.
As per me, the push down optimizations are mainly used for
performance enhancement of the workflows as there are some
logics which can be exected faster on the database compared
to Informatica.
Please let me know all your comments if any on the above.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
what is mean by complex business rule ?
How do you set a varible in incremental aggregation
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
To import the flat file definition into the designer where should the flat file be placed?
Performance tuning in UNIX for informatica mappings?
Explain lookup transformation source types in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can you use flat files in Mapplets.
How to generate sequence numbers without using the sequence generator transformation?
Difference between Target-based loading and constraint-based loading?
Briefly define a session task?
What are the databases that informatica can connect to windows?
What are connected or unconnected transformations?
What are the features of complex mapping?
