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
- 17645 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
How can we store previous session logs?
Explain Dataware house architecture .how data flow from intial to end?
can you please explain me pre session and post session options?
What is decode in informatica?
What are the performance considerations when working with aggregator transformation?
What are the differences between joiner transformation and source qualifier transformation?
What is rank transformation in informatica
What are the tasks that can be performed using sq?
How to do unit testing in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the tuning techniques you applied during your last project
difference between informatica 8.1.1 and 8.6
What is different between the data warehouse and data mart?
What are mapplets?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
