Hi there
I have a customer dimension table and I have attributes that are only relevant to some of the customers. If I included these attributes in the table it would mean that I have null (or a key that equals null) for many of the records. I may have a few of these types of attributes therefore possibly having many null values for each attribute added.
I wasn't sure if I should include these types of attributes in my main dimension table and have many fields with a null value or create a separate attribute table with a structure of customer_key, attribute_type, attribute_value where there may be many records for each product. This second option would obviously create a snow flake schema.
Thanks
I have a customer dimension table and I have attributes that are only relevant to some of the customers. If I included these attributes in the table it would mean that I have null (or a key that equals null) for many of the records. I may have a few of these types of attributes therefore possibly having many null values for each attribute added.
I wasn't sure if I should include these types of attributes in my main dimension table and have many fields with a null value or create a separate attribute table with a structure of customer_key, attribute_type, attribute_value where there may be many records for each product. This second option would obviously create a snow flake schema.
Thanks