28.4.2.2 Many to One Mapping

Many Credit Score Models can be mapped to one Regulatory Credit Score Model using the Mapper Maintenance screen. Here, you need to select two or more Credit Score Models and one Regulatory Credit Score Model. This means the corresponding data in Stage Account Credit Score Details Credit Score Model column for the selected Credit Score Models will be loaded into Fact Account Credit Score Details Regulatory Credit Score Model column while loading the T2T.

To perform Many-to-One mapping, follow these steps:

  1. In the Mapper Maintenance page, click Add.
  2. The Add Mappings page is displayed. In this example, MSG – Missing and OTH - Others are mapped to VANTAGE - Vantage Score.

    Figure 28-6 Add Mappings page for the Many-to-One Mapping


    This illustration shows the Add Mappings page for the Many-to-One Mapping. You can map multiple Credit Score Model codes to one Regulatory Credit Score Model code. Select the codes. Click Go to proceed with the mapping. Then click Save to save the mappings.

    To map, click Go and then to save the mapping, click Save. An acknowledgement is displayed. Click Yes to confirm.

  3. The mapped members are displayed in the Mapper Maintenance page.

    Figure 28-7 Added mappings listed in the Mapper Maintenance page


    This illustration shows the added mappings listed in the Mapper Maintenance page.