A. Whenever a session is created for a mapping Aggregate Transformation, the session option for Incremental Aggregation can be enabled. When PowerCenter performs incremental aggregation, it passes new source data through the mapping and uses historical cache data to perform new aggregation calculations incrementally.
Lookup: Lookup transformation is used in a mapping to look up data in a flat file or a relational table, view, or synonym.
Two types of lookups:
1) Connected
2) Unconnected
No comments:
Post a Comment