In the SAS^® Credit Risk Management for Banking intermediate job named Populate I_FINANCIAL_POSITION, the join between the FINANCIAL_POSITION table extract and the FINANCIAL_INSTRUMENT_ASSOC table is of the wrong type. Because it is an inner join, the resulting table can have too few records or be unpopulated. The join should instead be a right join.

As a workaround, use the following steps to update the join in the Populate I_FINANCIAL_POSITION job. These steps assume that you have already installed 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_POSITION 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. Change the INNER join to a RIGHT join.
5. Remove the join condition that is on VALID_FROM_DTTM.
6. Move the condition that is on FINANCIAL_INSTRUMENT_RK from the WHERE clause to the ON statement that is in the RIGHT join clause.
7. The modified SQL join should now look like the following:
   
   
   
   
8. Close the Populate I_FINANCIAL_POSITION –> 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