Bookshelf v7.8.3: Gathering Information About Your Data Warehouse and Staging Tables

Table 5 lists information about the data warehouse and staging tables. You can use this table as a worksheet and record the values applicable to your installation.

Table 5. Information About Your Data Warehouse and Staging Tables
Variable	Explanation	Your Value
STAGING AREA
$IA_SA_USERID	The database user ID to connect to the database housing the staging tables. It is recommended that this ID be the same user as for the data warehouse, $IA_DW_USERID. If this ID is different from the data warehouse user, this user must have select privileges on all the data warehouse objects. Create the appropriate grant and synonym creation scripts necessary for this purpose.
$IA_SA_PASSWORD	The password to connect to the database housing the staging tables. This password must be the same as the $IA_DW_PASSWORD password.
$IA_SA_DW_SERVER	The server housing the data warehouse and staging area databases (preferably the same for both).
$IA_SA_DATABASE	The database where the staging area and data warehouse tables reside (must be the same as $IA_DW_DATABASE).
DATA WAREHOUSE
$IA_DW_USERID	The database user ID to connect to the database housing the data warehouse tables. It is recommended that this user ID is the same as the user ID for the data warehouse, $IA_SA_USERID.
$IA_DW_PASSWORD	The password to connect to the database housing the data warehouse tables. It is recommended that this password is the same as $IA_SA_PASSWORD.
$IA_SA_DW_SERVER	The server housing the data warehouse and staging area databases (preferably the same for both).
$IA_DW_DATABASE	The database where the data warehouse tables reside (must be the same as $IA_SA_DATABASE).