Forum Discussion
Solved
Dim table’s id with nulls
I am creating a data model based on a star schema. But one of my dimension tables id column has 10 null rows. What is the best solution for this. options: 1. i could replace values but afraid if...
My view is filter them out. Don't load them. Also generate an audit query that lists any keys in your fact table that are missing in the dim table. That way you know what dims are missing, and you can fix these at the source.
Thanks MattAllington and Anonymous both are helpful solutions. I will try them both out in parallel. While i'm working on the fixing the data model i will also try to fix the values at the source of the data.