Database Reference
In-Depth Information
Processing option
Description
Used for
long time, unless you first
"unprocess" it.
This option loads a full
dataset into a partition,
and builds the necessary
indexes and aggregations.
Each partition must be fully
processed to provide optimal
querying performance.
ProcessFull
This option incrementally
updates an existing parti-
tion by defining the query
which returns only those
rows not already found in
the SSAS partition. The
query could include the
condition such as
re-
cord_create_date >
'last processed
date'
to limit the dataset.
Though rarely used, this in-
cremental processing option
is useful when your relation-
al source has an incomplete
dataset during the previous
execution of
ProcessFull
.
In the background, SSAS
creates a temporary parti-
tion, processes it, and sub-
sequently merges it with the
existing partition.
ProcessAdd
This option loads the full
dataset, but does not build
the aggregations and in-
dexes.
This option is useful on
32-bit implementations that
cannot use more than 2 GB
of memory. Separating data
and aggregation processing
could prevent SSAS from
running out of memory.
ProcessData
Search WWH ::
Custom Search