Option for incremental aggregation is enabled whenever a session is created for a mapping aggregate. Power center performs incremental aggregation through the mapping and historical cache data to perform new aggregation calculations incrementally.
ROLAP eg.BO, MOLAP eg.Cognos, HOLAP, DOLAP
One can group any number of sessions but it would be easier for migration if the number of sessions are lesser in a batch.
What do you mean by Enterprise Data Warehousing? What is target load order? Where can we find the throughput option in informatica? What is the use of target designer? What do you mean by worklet? What are the different types of OLAP? Give an example? What is OLAP (On-Line Analytical Processing? Tell me any other […]