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.
But it's a dim table with multiple nulls.