stage

Description

Stages data from a data source into stage tables.

Syntax

stage {update|replace|append} from {file|datasource|database} file_name using {file|stagemap|stagemaps} xml_file_name

stage {update|replace|append} using {stagemap|stagemaps} stagemap_names

stage clear {rowsource|cube|dimension} object_name

stage clear {rowsources|bom|dimensions}

Arguments

object_name—Name of the object; for example, row source, cube, or dimension name
xml_file_name—XML file name used to stage the data. This can be a loader xml file with load specifications or a stagemap file.
file_name—File containing the staged data; for example, a CSV or text file containing the input data
stagemap_names—A single stagemap name or a list of stagemap names

Example

stage update using stagemap \"SM_IntercompanyDemandRise\"
stage update from file \"$f\" using file \"$migrationHome/loader/load-rowsource-$rs.xml\"
stage update from datasource Orders using stagemaps OrdersMap,OrderLinesMap
stage update from datasource Forecast using stagemap  ForecastMap
stage replace using stagemap \"ForecastHistory\"
stage replace from file \"demo-bom.csv\" using file \"load-bom.xml\"
stage replace using stagemaps \"ETLSalesOrders_SalesOrders\" ,\"ETLSalesOrders_DailySalesOrders\"