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:
- In the Mapper Maintenance page, click Add.
- 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
To map, click Go and then to save the mapping, click Save. An acknowledgement is displayed. Click Yes to confirm.
- The mapped members are displayed in the Mapper Maintenance page.
Figure 28-7 Added mappings listed in the Mapper Maintenance page