What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?
Answer Posted / sudhar
Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.
Is This Answer Correct ? | 31 Yes | 4 No |
Post New Answer View All Answers
r u done any partitions in ur project?
What is the sql query overwrite in source qualifier in informatica
What is a stored procedure transformation?
How do you migrate data from one environment to another?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How an expression transformation differs from aggregator transformation?
Explain target update override in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is informatica worklet?
What is the difference between stop and abort in informatica
What is the difference between source qualifier transformations source filter to filter transformation?
What are the reusable transformations?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Define filter transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?