cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Surveyor

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

Jump to solution

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? 

0 Kudos
1 Solution

Accepted Solutions
Highlighted
Surveyor

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!.

View solution in original post

0 Kudos
1 Reply
Highlighted
Surveyor

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!.

View solution in original post

0 Kudos
Top Kudoed Authors