Skip to main content

0 questions
21 posts

Do you have questions about Technical?

Log in to ask questions about Technical publicly or anonymously.

Anna RiderSemarchy Team
Customer Success Consultant at Semarchy

Example of Advanced Validation Rule using ANY and checking values of Foreign Keys

This article gives an example of an advanced validation rule that navigates to parent and child records from a central entity (Customer). If you are struggling to write SemQL for a complex business requirement, this example might give you ideas on how to structure your own validation rule.

Business Background

This is a Customer B2B use case. Here are some relationships between entities in this B2B data model.

  • Customers (child) belong to a MasterCustomer (parent)
  • MasterCustomers (parent) can have many SubGroups (child). SubGroups are a way to categorize different Customers within 1 MasterCustomer.
  • Customers can belong to many SubGroups... (More)
Anna RiderSemarchy Team
Customer Success Consultant at Semarchy

How to get existing values so that blank/null columns in updates are populated with data


If you have updates to an existing record in xDM but the update does not load every column/attribute, there is a risk that you may have null/blank values after performing the update.

Here's an example.

Day 1: Imagine you have these Customer records.

When you load an update, you may only have the following new information to update Mary-Ann Markes (she changed her last name).

Day 2: Data update

If you load this update to Mary-Ann's record via ETL, you may end up with null for the DateOfBirth and MemberID fields because you didn't provide those values in... (More)

Anna RiderSemarchy Team
Customer Success Consultant at Semarchy

How to calculate a UPC (Universal Product Code) and other intelligent keys in xDM


Product data often has intelligent keys, such as product codes and IDs. One of the most common is the UPC (Universal Product Code).

xDM can generate these intelligent keys to help the business set up unique IDs. This applies to domains, such as Product, Customers, Locations, and many more.

In this article, let's look at how xDM can help generate UPCs to provide products with unique IDs that follow patterns or rules. This example extends to other use cases where it is important to follow an algorithm to generate keys and IDs.

How UPCs work

You likely recognize UPCs... (More)

Anna RiderSemarchy Team
Customer Success Consultant at Semarchy

Advanced technical troubleshooting and optimization for slow matching performance

Matching performance is a complex issue. There could be many causes that lead to unsatisfactory integration job processing times, including poorly optimized match rules that perform too many fuzzy-matching comparisons or logic bugs that ensure your integration jobs will simply never finish.

Assuming your data volumes are large and you've got adequate hardware allocated to xDM (memory, storage specs for the application server and database), if you've optimized and feel confident that there's no more to be gained by tweaking match rules, here are steps you can try to speed up your integration jobs.

These steps are very technical and... (More)