Integrating QAD Data Warehouse Designer into an Existing Warehouse > Parameters
  
Parameters
The procedure must have the following parameters in the following order:
Parameter name
Input/Output
Oracle Type
SQL Server/DB2 Type
p_sequence
Input
Number
Integer
p_job_name
Input
Varchar2
Varchar(256)
p_task_name
Input
Varchar2
Varchar(256)
p_job_id
Input
Number
Integer
p_task_id
Input
Number
Integer
p_return_msg
Output
Varchar2
Varchar(256)
p_status
Output
Number
Integer
The input parameters are passed to the procedure by the scheduler. If the procedure is called outside the scheduler then the normal practice is to pass zero (0) in the sequence, job_id and task_id. A description of the run can be passed in the job name and the task name is typically the name of the procedure.
The output parameters must be populated by the procedure on completion. The return_msg can be any string up to 256 characters long that describes the result of the procedures execution. The status must be one of the following values:
Status
Meaning
Description
1
Success
Normal completion
-1
Warning
Completion with warnings
-2
Error
Hold subsequent tasks dependent on this task
-3
Fatal Error
Hold all subsequent tasks
The major task in integrating a procedure will be in adapting it to the QAD scheduler standards and work flow.
 
Integrating, Views
When integrating views an additional step is required if you want QAD Data Warehouse Designer to be able to recreate the view.
The view will be mapped correctly and the 'Get Key' function can still be built. This step is only required if the view is to be re-created.
Change the source column on the artificial key to match the artificial key in the table from which the view was created.
 
Integrating, QAD Tables
When integrating QAD generated tables and views a number of additional considerations need to be taken.
The Dimension tables and views make use of secondary business key columns such as dss_source_system_key, dss_current_flag, dss_end_date, dss_version to assist in handling various forms of slowly changing dimensions and non conformance. These secondary business keys need to be flagged as such against the dimension.
Change the properties of all such columns. The key type should be set to 1, and the primary business key check box should be set.