Interested to Buy Any Domain ? << Click Here >> for more details...
How we will implement Pushdown Optimization and Types in Informatica with better examples
- 4 Answers
- 14033 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
In warehouses how many schemas are there?
draw informatica architecture 8.6 ?
What is the Process to creating lookup transformation in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
Why update strategy and union transformations are active?
How to update or delete the rows in a target, which do not have key fields?
How many numbers of sessions can one group in batches?
How to open an older version of an object in the workspace?
What is an expression transformation in informatica?
What is meant by active and passive transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by query override?
What is the meaning of decode in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
