-
Aggregation
can anyone tell me about 1)aggregation at microcube level2)aggregation at database level
devgod
- May 23rd, 2009
Aggregation can be of the following type: Table Level: Commonly known as Marts.L1/L2 marts at monthly/yearly levels. Query Level: Make use of Database aggregate functions like SUM, COUNT, MAX, M...
Rajnish_kaushal
- Apr 13th, 2009
Aggregation : In SQL we have functions e.g. Sum , min , max , count etc for aggregating the data. We can use these functions to create objects in universe for aggregating at database level. Also when ...
-
What is the difference between mapping parameter & mapping variable in data warehousing?What are the types of variable available in data warehousing?
dhiveya.m
- Apr 22nd, 2009
Mapping parameter are the constant values (values never changes) and mapping variables are the values that ever changes.
fir_dan
- Jul 18th, 2008
A mapping parameter is a static value that you define before running the session and it retains the same value till the end of the session. Define a parameter in paramaeter file (.par) and use it in m...
