Staging data is a best
practice because you can use the data builder to access and transfer
data from operational systems once, rather than frequently interfere
with the operational systems and reduce their performance. Using the
data builder to stage data can provide the advantage of adding calculated
columns when you stage the data.
Like the output table,
the staging table is registered in metadata when you save the data
query. The physical table for the staging table is created when you
run the data query.
You cannot specify the
name for a staging table. The name of the output table is used, and
an
__STG (with two underscores)
suffix is applied to the name. The suffix is used for the table name
in metadata. The physical name of the staging table does not include
the suffix.