In the SAS® Credit Risk Management for Banking intermediate job named Populate I_FINANCIAL_INSTRUMENT, the join condition between the FINANCIAL_INSTRUMENT table and the TIME_FREQUENCY table is incorrect.

The join condition reads:

Moreover, there is an extraneous condition on the WHERE clause.

The WHERE clause reads:

If you run this job without making these changes, then the target table (I_FINANCIAL_INSTRUMENT) is incorrectly populated.

As a workaround, use the following steps to update the Populate I_FINANCIAL_INSTRUMENT job with the correct join condition. These steps assume that you have already installed the SAS® Detail Data Store for Banking and unpackaged the SAS Credit Risk Management for Banking ETL jobs (see "How to Install the ETL Jobs" in the SAS^® Credit Risk Management for Banking: Administrator's Guide):

1. Open SAS® Data Integration Studio.
2. In the Folders Tree, double-click the Populate I_FINANCIAL_INSTRUMENT job name. You can now see the ETL job flow in the Job Editor.
   
   
   
   
3. In the Job Editor, right-click the SQL Join node, and then select Open. The SQL join opens in the Job Editor.
4. In the Navigation pane, select the third Join. You can now see a table with the join clauses at the left of the Navigation pane.
   
   
   
   
5. In the second row of the table, select the first Operand column. Then, click the arrow at the right of this field, and select Choose Column(s).
6. Select the TIME_FREQUENCY.VALID_FROM_DTTM column, and click OK.
   
   
   
   
7. In the Navigation pane, select the WHERE clause. You can now see a table with the join clauses at the left of the Navigation pane.
   
   
   
   
8. Select the second row of the table, and click Delete.
9. Close the Populate I_FINANCIAL_INSTRUMENT -> SQL Join* window. When prompted, select Yes to save your changes.

After you have edited the join condition in this ETL job, continue through the remaining documented steps for ETL Job Deployment in the SAS® Credit Risk Management for Banking: Administrator's Guide.

Operating System and Release Information