|
Data Warehouse |
|
|
[SSAS] |
|
|
Questions: |
Notes: |
|
What is the Process Full mode? |
Processes an Analysis Services object and all the objects that it contains.
When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object.
This kind of processing is required when a structural change has been made to an object, for example, when an attribute hierarchy is added, deleted, or renamed.
This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions. |
|
What is the Process Incremental mode? |
Adds newly available fact data and process only to the relevant partitions.
This processing option is supported for measure groups, and partitions. |
|
What is the Process Update mode? |
Forces a re-read of data and an update of dimension attributes.
Flexible aggregations and indexes on related partitions will be dropped.
For example, this processing option can add new members to a dimension and force a complete re-read of the data to update object attributes. This processing option is supported for dimensions. |
|
What is the Process Index mode? |
Creates or rebuilds indexes and aggregations for all processed partitions.
This option causes an error on unprocessed objects. This processing option is supported for cubes, dimensions, measure groups, and partitions. |
|
What is the Process Data mode? |
Processes data only without building aggregations or indexes.
If there is data is in the partitions, it will be dropped before re-populating the partition with source data. This processing option is supported for dimensions, cubes, measure groups, and partitions. |
