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
- 17475 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manojkumar
Thanks you so much parikhita.
Can you give me the exact two options(use view,..) which
will enabled when we select pod and how these options will
work?
When I select pod on source side, what about target insert
or update query ? will it be pushed to target db? Or only
select query will be pushed to source db ?
and when do we need to go for pushdown optimization
technique ? ofcourse it increses the performance. But at
what situation or circumstances we need to go for pod ?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
Why do we need informatica?
COM components can be used in Informatica
Define filter transformation?
What is DR strategy for Informatica project?
What are the types of caches in lookup?
How to do unit testing in informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the differences between joiner transformation and source qualifier transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How many ways are there to create ports?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the advantages of using informatica as an etl tool over teradata?
Explain the code page compatibility?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
