Reltio Connect

 View Only
Expand all | Collapse all

Reltio Location Cleanser record and identifying the "linked" crosswalk

  • 1.  Reltio Location Cleanser record and identifying the "linked" crosswalk

    Posted 08-29-2022 14:43

    Hello:

    Is there a way to identify which location entity crosswalk the ReltioCleanser record is linked to? Or how the cleanser selects the crosswalk to actually cleanse based on?

    We have a location entity where a match rule will merge records with the same standardized address.  Each contributing system/key has a crosswalk for the location entity.    Simple example data below:

    Source: Address~City~State~Zip

    CIS: 1730 GIBBS SHOALS RD~GREER~SC~29650
    JDE: 1730 HIBB SHOALS ROAD~GREER SC~29650
    CDB: 1730 GIBBS SHOALS RD~GREER~SC~29650

    All 3 of these addresses cleansed to 1730 GIBBS SHOALS RD~GREER~SC~29650 and merged to the same entity.

    The cleanser record does not list a DPV_Flag or Footnotes for the "Golden" Address 1730 GIBBS SHOALS RD~GREER~SC~29650 .  The address is CASS DPV:Y AABB.  If we recleanse the entity manually or delete the cleanser crosswalk this behaviour doesn't change, we still end up with the same result.

    We are trying to get the cleanser to trigger and give us the CASS information that corresponds to the "Golden" Address, not the one contributor that it seems to be "Stuck" on.  Or if we can identify what crosswalk the cleanser is linked to we can work from there.

    We are trying to get the CASS attributes on our location entities updated but we are blocked by the way Reltio is picking the crosswalk to recleanse from.

    Any guidance would be appreciated.


    Cheers
    Jim Mattheiss
    Scholastic Inc.



  • 2.  RE: Reltio Location Cleanser record and identifying the "linked" crosswalk

    Reltio Employee
    Posted 08-30-2022 10:46
    Hi Jim,

    When multiple location profiles are merged, the platform drops the ReltioCleanser crosswalk for each of those profiles first, and then it cleanses the OV values resulting from that merge.  The cleansed values are stored in the ReltioCleanser crosswalk attached to the consolidated profile. 

    The same happens during re-cleansing, the cleanser crosswalk is deleted and then recreated based on OV values.

    In you example, can you try finding out what should be the OV values prior to cleansing, that would give you the clue on which address elements are used for cleansing.


  • 3.  RE: Reltio Location Cleanser record and identifying the "linked" crosswalk

    Reltio Employee
    Posted 09-01-2022 01:24


  • 4.  RE: Reltio Location Cleanser record and identifying the "linked" crosswalk

    Reltio Employee
    Posted 09-01-2022 01:25
    Hi Jim,

    Assuming that the CASS cleansing is enabled on the Tenant, you can verify the following points as well:
    1. There is a setting in the Tenant Physical config that determines whether OV values are used for cleansing or non-OV value are also used for cleansing. You can find more information about this property from the following link:
    https://docs.reltio.com/datacleanse/addresscleansingprop.html#:~:text=This%20property%20is,ov%22%3A%22true%22%20values.
    2. I believe CASS attributes are not mapped by default, they need to be mapped explicitly in the CleanseConfig outputMapping section in the L3, following link has these field details, if this is the case then you would not see CASS fields populated for any of the addresses in the Tenant.
    https://docs.reltio.com/datacleanse/addcassfields.html