DAC Source system parameters

Parameter	Description	Parameter Name	Default
Analysis Start Date	The start date used to build the day dimension and to flatten exchange rates and costs lists.	$$ANALYSIS_START, $$ANALYSIS_START_WID	Jan 1, 1980
Analysis End Date	The end date used to build the day dimension and to flatten exchange rates and costs lists.	$$ANALYSIS_END, $$ANALYSIS_END_WID	Dec 31, 2010
Max Days in a SalesStage	Applicable to opportunities only. The maximum number of days an opportunity can spend in a sales stage.	$$MAX_DAYS_IN_STG	30
Default Language	Siebel Specific. The language into which columns’ display strings are translated.NOTE: Language-independent strings are stored in the _l columns. If you do not know the default language setting, issue the following query against the transactional database: select VAL from S_SYS_PREF where SYS_PREF_CD=’ETL Default Language'; 12-MAL12D	$$DFLT_LANG	ENU
Alignment Version	Applicable to Siebel vertical applications only. Seed data needs to be updated in certain lists of values to make sure that the ETL process correctly populates the alignment type and product category relationships in the Oracle Business Analytics Warehouse.This setting is used by Siebel Life Sciences to control loading of changes in assignment rules in Siebel Assignment Manager.	$$ALIGNMENT_VER	Y
Maximum LOV Size	Siebel specific parameter. Numeric LOVs must have a maximum value for proper analysis and consistent data in the data warehouse. This value determines what the maximum value will be	$$LOV_MAX_VAL	9999999999
Minimum LOV Size	Siebel specific parameter. Numeric LOVs must have a minimum value for proper analysis and consistent data in the data warehouse. This value determines what the minimum value will be	$$LOV_MIN_VAL	0
Type 2 Flag	Slow changing dimension (Type-2) specific parameter. If this dimension is “capable” of storing history, you can choose to set the flag value to be ‘Y’ or ‘N’. If set to ‘Y’ and you have already identified columns that your history tracking mechanism will be based upon, then this will trigger insertion of new records with new surrogate keys whenever anything history tracking event happens. If set to ‘N’, it just updates the existing record.	$$TYPE2_FLG	Y (This is just an out of box setting. The value of this parameter should be overridden at a task level, because not all dimensions will have the same setting.)
Update All History Flag	Applicable for slowly changing dimensions (Type-2). With a Type-2 change happening along with some other changes in a non-history tracking column, you can choose to update values of that non-Type2 column for all historical records. If so, set this flag to ‘Y’. If you want to preserve the old values for non-Type2 columns for older records, set this to ‘N’.	$$UDATE_ALL_HISTORY	Y (Recommended approach and out of box setting).
Language Code	Datawarehouse language that is used to resolve NAMES for the CODES in your system.	$$LANGUAGE_CODE	E (out of box setting)
Global1 Currency Code	Generic parameter identifying the global (Data Warehouse) currency code. Three distinct global currencies are supported; this is the first of the three.	$$GLOBAL1_CURR_CODE	USD
Global2 Currency Code	Generic parameter identifying the global (Data Warehouse) currency code. Three distinct global currencies are supported; this is the second of the three.	$$GLOBAL2_CURR_CODE	USD
Global3 Currency Code	Generic parameter identifying the global (Data Warehouse) currency code. Three distinct global currencies are supported; this is the third of the three.	$$GLOBAL3_CURR_CODE	USD
Global1 Exchange Rate Type	Generic parameter identifying the default exchange type to be used against the Global1 (Data Warehouse) currency code.	$$GLOBAL1_RA TE_TYPE	Value of this parameter is source specific. For Siebel Sources, the default value is “Actual”. In case of Oracle and Universal Adapters, the value is overridden with “Corporate”.
Global2 Exchange Rate Type	Generic parameter identifying the default exchange type to be used against the Global2 (Data Warehouse) currency code.	$$GLOBAL2_RA TE_TYPE	Value of this parameter is source specific. For Siebel Sources, the default value is “Actual”. In case of Oracle and Universal Adapters, the value is overridden with “Corporate”.
Global3 Exchange Rate Type	Generic parameter identifying the default exchange type to be used against the Global3 (Data Warehouse) currency code.	$$GLOBAL3_RA TE_TYPE	Value of this parameter is source specific. For Siebel Sources, the default value is “Actual”. In case of Oracle and Universal Adapters, the value is overridden with “Corporate”.
Default Local Exchange Rate Type	Generic parameter identifying the default exchange rate type to be used against the local (OLTP) currency code, in case the same is not available from the source.	$$DEFAULT_LOC_RATE_TYPE	Value of this parameter is source specific. For Siebel Sources, the default value is “Actual”. In case of Oracle and Universal Adapters, the value is overridden with “Corporate”.
Current Date	These are runtime parameters that gets the value of the current date and the current quarter based on the date dimension, W_DAY_D, against the Fiscal or Gregorian calender, as the case may be.	$$CURRENT_DATE	Value obtained through firing SQL at the runtime.
Current Quarter		$$CURRENT_QUARTER	Value obtained through firing SQL at the runtime.
Data Source Number Identifier	This is a static parameter used to identify the source system type and its instance. For example, you could set ‘2’ for the first instance of Oracle 11.5.8 source, and ‘3’ for the second instance of Oracle 11.5.8, ‘4’ for the only instance of Oracle 11.5.10 and ‘5’ for Siebel OLTP source, and so on.This is a runtime parameter that increments by 1 (normally) for each ETL run. For instance, for the first full load, it might start with a 1. Then the first incremental ETL run gets a 2 and so on. This helps in identifying records that were affected during a given ETL run.	$$DATASOURCE_NUM_ID	Value is different for different containers, for example 3 for Oracle 11.5.8 and so on.
ETL process Identifier		$$ETL_PROC_WID	DAC generated. Normally starts with a 1 and then increments by 1.
Dates used for incremental extraction	This date is used to extract data for the full load.	$$INFA_LOAD_DT, $$INITIAL_EXTRACT_DATE	01/01/1970
Last Extract Date	This date is used to extract data during everyday incremental loads	$$LAST_EXTRACT_DATE$$JULIAN_LOAD_DT	Runtime, DAC generated. Based on when the last date/time extraction (ETL) happened.
ETL Load Date	The ETL load start Date	$$LOAD_DT	Runtime, DAC generated
Exception reporting for CODE-NAME pairs	This static parameter value is used to substitute the CODE part in (mostly) dimension tables when the master code (standardized code) was not found during code lookup against the supplied value of source side code.	$$MASTER_CODE_NOT_FOUND
Exception reporting for CODE-NAME pairs	This static parameter value is used to substitute the CODE part in (mostly) dimension tables when the code lookup failed to resolve to the standardized code in the event where the source-side code itself was not supplied in the staging area tables.	$$SOURCE_CODE_NOT_SUPPLIED	<null value> out of the box. But can be any string like “master code is not found” up to a limit of 30 characters.
Tenant Identifier	This is a static parameter used to identify the tenant id, in multi-tenancy situations.	$$TENANT_ID