Configuring the Standardize stage to generate SQA report columns

After you add the SQA stage to a job, you must configure the Standardize stage to generate additional columns that are used to create SQA reports.

Before you begin

Before you configure the Standardize stage to generate SQA report columns, complete the following task:

Add the SQA stage to a job that processes the output of the standardization job Optionally, you can add the SQA stage directly to a Standardize stage job.

About this task

The SQA stage requires additional output columns from the Standardize stage to generate data for the SQA reports. When you alter the Standardize stage to produce additional output columns, consider the implications that additional output columns have for your job. When the Standardize stage generates additional data for the SQA stage, a column named qsSqaStI_rule set name is added for each standardization process that is configured in the Standardize stage. This column contains the subset input data field that is processed by that particular rule set for that input record. For example, target databases that the Standardize stage writes to must be altered to account for the additional columns that are generated.

Procedure

Open the standardization job for which you want to create an SQA report.
Double-click the Standardize stage and click Stage Properties.
In the Stage > Properties tab, add the SQA Report Output property and verify that the property value is set to True.
Map the output columns of the Standardize stage to the input columns of the stage whose data will be used by the SQA stage. Remember that the SQA stage can directly receive output from the Standardize stage. In addition, the SQA stage can receive output from another stage (such as a Sequential File stage) which reads data from a file that contains the output of the standardization job.
Note: You must preserve the order of the output columns when you map them.
If the SQA stage is not directly linked to the Standardize stage, ensure that you reconfigure the necessary stage or stages to accommodate the additional output columns from the Standardize stage.
Run the standardization job after you configure it to generate the additional columns for the SQA stage.