Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse >
About Modifying Session Parameters for Initial and Incremental Loads
Parameters are designed to regulate the behavior of workflows and tasks, and are set using a source file. Siebel Customer-Centric Enterprise Warehouse supplies this file. However, you must modify the appropriate CSV parameters source file to set up your ETL process frequency. For a list of parameter source files for every source application folder see Table 10.
Table 10. Source Application Folders and Parameter Source Files
Source Application Folder |
|
Configuration for Oracle Applications v11i |
file_parameters_ora11i.csv |
Configuration for PeopleSoft 8.4 |
file_parameters_psft84.csv |
Configuration for SAP R/3 |
file_parameters_sapr3.csv |
Configuration for Universal Source |
file_parameters_univ.csv |
Configuration for Post Load Processing |
file_parameters_plp.csv |
Table 11 is an example of the file_parameters_psft84.csv parameter file. It shows a number of important columns and example sessions for the file_parameters_psft8.csv parameter file.
Table 11. Example of the file_parameters_psft84.csv Parameter File
|
|
|
|
|
|
|
PSFT84 |
S_M_P_AP_XACTS_VCHR_ACCTG_LINE_GL_REFERENCE_EXTRACT:LAST_EXTRACT_DATE |
0 |
D |
MPLT_BCP_AP_XACTS_VCHR_ACCTG_LINE_GL_REFERENCE_EXTRACT |
200400101000000 |
PSFT84 |
PSFT84 |
S_M_P_AR_XACTS_BI_ACCT_ENTRY_GL_REFERENCE_EXTRACT:LAST_EXTRACT_DATE |
0 |
D |
MPLT_BCP_AR_XACTS_BI_ACCT_ENTRY_GL_REFERENCE_EXTRACT |
20040101000000 |
PSFT84 |
PSFT84 |
S_M_P_AR_XACTS_ITEM_DST_GL_REFERENCE_EXTRACT:LAST_EXTRACT_DATE |
0 |
D |
MPLT_BCP_AR_XACTS_ITEM_DST_GL_REFERENCE_EXTRACT |
20040101000000 |
PSFT84 |
PSFT84 |
S_M_P_GL_COGS_CM_ACCTG_LINE_GL_REFERENCE_EXTRACT:LAST_EXTRACT_DATE |
0 |
D |
MPLT_BCP_GL_COGS_CM_ACCTG_LINE_GL_REFERENCE_EXTRACT |
20040101000000 |
PSFT84 |
The following are the important columns in the parameter file: - PARM_TYPE. The PARM_TYPE column represents the source system you are working on. For example, PeopleSoft 8.4 has a value of PSFT80.
- PARM_CODE. The PARM_CODE column contains the name of the session concatenated with the session parameter name. You have to configure this value. For example, in both the initial and incremental extracts mappings in Table 11, you use the LAST_EXTRACT_DATE parameter.
- PARM_NVALUE_1. The PARM_NVALUE_1 column represents the number of days you want to use as your extraction window. For your initial loads, the value is 0. For incremental loads with a window of 4 days from the current system date, the value is 4. For more information on configuring these dates, see Configuring the Date Parameters for Parameter Files.
- PARM_SVALUE_1. The PARM_SVALUE_1 column represents the type of parameterization being done. For example, when configuring dates the value is D.
- PARM_SVALUE_3. The PARM_SVALUE_3 column represents the mapplet name. For Siebel Business Analytics, most of the extraction logic is hidden in the business component mapplet. The mapplet name corresponds to the PARM_CODE column.
- PARM_DVALUE_1. The PARM_DVALUE_1 column represents the date that is used for initial runs. The value from this column is used only when PARM_NVALUE_1 has a non-zero value.
- SOURCE_ID. The SOURCE_ID always represents the source system you are working on. For example, PeopleSoft 8.4 has a value of PSFT84.
|