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
- 17524 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
r u done any partitions in ur project?
What are the limitations of joiner transformation?
What is enterprise data warehousing?
How do you remove duplicate records in informatica? And how many ways are there to do it?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How can we update a record in the target table without using update strategy?
Can u generate reports in Informatica?
What are data-driven sessions?
How to start a workflow using pmcmd command?
What is a repository manager?
Write the program through which the records can be updated?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is target load order?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you promote a non-reusable transformation to reusable transformation?
