Database Reference
In-Depth Information
Note
If you process a partition fully or incrementally, you may get an error which refers
to duplicate keys. This will happen when the data you add causes a duplicate key
to appear in tables or relationships that require unique values within the model.
Process Defrag
optimizes the table structures within the model. This is essentially
a clean-up operation that should be run occasionally to keep the solution running
smoothly.
Finally, the
Process Add
option only applies to the
Process Partition
option. This
option allows you to add only new data. SSAS does not check the existing data, so
you are responsible for making sure the partition can accept new rows and not run
into duplicates.
Note
In order to get to the
Process Partition(s)
dialog, you need to right-click on the
table and select the
Partition
option. This will open the partitions dialog box.
Click on the
Processing
button (three green arrows in a circle) to open the dia-
log.
There's more…
Table-based processing means you can choose volatile tables to process more fre-
quently. Because of the nature of how relationships are built; "bad" data will not pre-
vent the processing of data where related data is missing. This happens because the
data in a Tabular Model is essentially outer-joined.
See also
• There is no incremental or partial process supported outside of partitions.
You can learn how to create partitions in the next recipe.
Search WWH ::
Custom Search