In the staging job named ETL03_LOAD_DATAMART_CRM_ACCOUNT, the join between the I_CREDIT_RISK_MITIGANT table extract, the I_FINANCIAL_COLLATERAL table, and the I_PRIMARY_CPTY_CR_MITIGANT table is missing a subsetting condition. Without the condition, the resulting table can have too many records.

As a workaround, use the following steps to update the join in the ETL03_LOAD_DATAMART_CRM_ACCOUNT job. These steps assume that you have already installed SAS® Detail Data Store for Banking. They also assume that you have 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 ETL03_LOAD_DATAMART_CRM_ACCOUNT 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 first join. You can now see a table with the join clauses at the left of the Navigation pane.
   
   
   
   
5. Click New to add a row to the table.
6. In the second row of the table (which you have just added), select the first Operand column. Then, click the arrow at the right of this field, and select Advanced. The Expression Builder opens.
7. Enter NOT MISSING(I_FINANCIAL_COLLATERAL.ACCOUNT_RK) in the Expression Text box. Then, click OK to save the expression to the Operand column.
8. In the second row of the table, select the text (an equal sign) in the Operator column, and delete it. The updated Join condition SQL code should read:
   I_FINANCIAL_COLLATERAL.FINANCIAL_COLLATERAL_RK = W52YU71V.FINANCIAL_COLLATERAL_RK and NOT MISSING(I_FINANCIAL_COLLATERAL.ACCOUNT_RK)
   
   
   
   
9. Close the ETL03_LOAD_DATAMART_CRM_ACCOUNT -> 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