In this post we show you how to achieve ID mapping in a data warehouse efficiently using SQL. This, however, scratches the surface of the problem of ID mapping. People have worked on developing sophisticated probabilistic techniques to associate IDs using statistical and machine learning approaches. The data warehouses themselves are adding in-house machine learning capabilities.

Stay tuned, we’ll explore that in the future.