1. Using Pipeline Designer
  2. Configuring KYC Risk
  3. Changing KYC Risk to Staging Data

Changing KYC Risk to Staging Data

To provide customer KYC risk values from staging data, such as from STG_PARTY_MASTER.N_KYC_RISK, you must change the mapping in the ‘Load Customer Data’ pipeline from Direct to Type2.

To change the mapping, follow these steps:
  1. Navigate to the Pipeline Designer page.
  2. Search for and open the Load Customer Data pipeline.
  3. Copy and rename the pipeline, following the steps in Copying Pipelines.
  4. In the new pipeline, open the Customer Dimension_1 Persist widget and scroll until you reach the Map panel.

    Figure 9-1 Map panel

    The Map panel displays fields associated with the dataset and their details
  5. Enter Customer KYC risk in the Search by Target Column search field. The following mapping displays:Expression NVL( [Stage Party Master.Customer Kyc Risk Number] , ‘ 0 ‘)
    • Target Column: Customer Kyc Risk Number
    • Target Entity: Customer Dimension
    • Option: Direct
  6. Click Remove Remove icon to remove the mapping.
  7. Replace the Customer Lookup mapping by selecting Stage Party Master from the drop-down list.
  8. Select Customer Kyc Risk Number from the available list values.
  9. In the Customer Dimension mapping, select Customer Kyc Risk Number from the available list of values.
  10. Build the expression by following these steps:
    1. Click Add Expression Add icon.
    2. Enter NVL in the Condition field and then select an Opening bracket “ ( “.
    3. Select the Select Attributes checkbox.
    4. Select Stage Party Master from the Dataset drop-down list.
    5. Select Customer Kyc Risk Number from the Attribute drop-down list.
    6. Select a “ , ” comma and type “ 0 “ in the Condition text field, then select a closing bracket “ ) “.
    7. Click Save Save icon to save the new expression.
    NVL( [Stage Party Master.Customer Kyc Risk Number] , 0 )
  11. Change the mapping option from Direct to Type2 in the drop-down list and click Map .
  12. Verify the mapping is correct by typing Customer KYC risk in the Search by Target Column search field. The mapping should be displayed as follows:
    Expression NVL( [Stage Party Master.Customer Kyc Risk Number] , 0 )

    Target Column: Customer Kyc Risk Number

    Target Entity: Customer Dimension

    Option: Type2

  13. Click Save Save icon to save the Customer Dimension_1 Persist widget.
  14. In the Pipeline Designer page, click Saveto save all updates.