Header Ads

How to enable multiple population(Multi-Population) in a Base Object in Informatica MDM?




We can enable Multiple populations in a base object to tackle the issues related to the data from different population.Local patterns and language variations in different populations are considered if we use multiple population on data from customers over the world.This enhances the matching ability and thereby result in the creation of accurate master records in Base Object.

How to enable:
1)Get the population files of required countries from Informatica Support and copy the files(ysp files) in the below location.

Windows:

<infamdm_install_dir>\cleanse\resources\match

Unix:

<infamdm_install_dir>/hub/cleanse/

2)Update the column(flag) enabled_ind=1 for all the required countries in system table C_REPOS_SSA_POPULATION and Restart the application server.

Update C_REPOS_SSA_POPULATION set ENABLED_IND='1' where POPULATION_NAME IN ('US','Finland','Denmark')

3)Add a VARCHAR column in the Base Object with the physical name SIP_POP.This column will contain population data.(Eg : US,Denmark etc)
4)In the Match/Merge setup ,set SIP_POP as an exact column under Fuzzy strategy.

5)For non-default population records in the SIP_POP provide value by any of the below method:


  • Adding the data in the landing tables
  • Using cleanse functions that calculate the values during the stage process
  • Using SIF requests from external applications
  • Manually editing the cells using the Data Manager tool


5)Execute the Match& Merge process.Matching will happen within the same population only.

2 comments:

  1. Nice and very well defined blog thanks for sharing. Know more about Informatica MDM Training

    ReplyDelete
  2. I think there is a need to provide some more information about Informatica and its uses.Although this blog is still very informative.

    Informatica Read Rest Api

    ReplyDelete

Powered by Blogger.