|
Data Warehouse |
|
|
[SSAS] |
|
|
Questions: |
Notes: |
|
What is the Unprocess mode? |
Drops the data in the object specified and any lower-level constituent objects.
After the data is dropped, it is not reloaded.
This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions. |
|
What is the Process Structure mode? |
If the cube is unprocessed, Analysis Services will process, if it is necessary, all the cube’s dimensions.
After that, Analysis Services will create only cube definitions. If this option is applied to a mining structure, it populates the mining structure with source data.
The difference between this option and the Process Full option is that this option does not iterate the processing down to the mining models themselves. This processing option is supported for cubes and mining structures. |
|
What are Degenerated Dimensions? |
Degenerated Dimensions are dimensions that have all of their attributes already in the Fact table.
So the dimension is merged with the fact table and the fact table serves as a dimension as well.
This degenerated dimension may have keys which point to other dimensions.
Example: DimSalesReason is related to FactInternetSalesReason via ReasonKey. FactInternetSalesReason is related to FactInternetSales via OrderKey and OrderLineKey. OrderKey and OrderLineKey are attributes of the Degenerated Dimension of the FactInternetSales table. |
|
What is the most important aspect of OLTP data? |
The data from the OLTP has to be accurate.
The OLTP is there to track business processes. |
