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.
You cannot specify the name for a staging table. The name of the output table is used,
and an
_STG 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.