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.
I would replace null IDs in your fact table with a value, say "AB123", and then replace your nulls in the dimension table with the same "AB123". Then remove your duplicates from the dimension column. All of your nulls will show up under ID Number "AB123".
But yeah, don't leave the nulls in your dimension tables.
--Nate