[ARCHIVED] User ID recorded in Requests table with no corresponding user in user_fact or user_dim?

[jrkinsella]

We have a puzzle and are wondering if anyone else could point us in the right direction.  We are running some queries on our data (we pull our data into SQL nightly) and noticed a significant number of entries in the Requests table where there is a user_id recorded but when we then check that against user_dim, there is no corresponding record. So we are scratching our heads understanding how that could be and whether those are requests we need to include or exclude in this and future queries.

Any ideas why request user_id's wouldn't have a corresponding recording in user_dim or user_fact? 

[jrkinsella · Accepted solution]

Mystery solved!  Turns out we had an issue with the data being exported out to Excel before doing the user_dim check and excel rounding off the last 4 digits of the user id.  Easy and silly mistake to make on our part!.