Why do I have to have an ID and a Dimension_Key in my dimension
I am not understanding why I have to have an ID and a dimension_key that is generated in my dimension.
When creating a dimension I only want to have a DIM_ID which would be the generated surrogate key from the sequence number generator.
When you generate a dimension it automatically puts the ID in and selects surrogate key. The Name attribute that it puts in would be my human readable key, so what does it insist on me having two keys in a dimension and in reality a table that do the same thing.
I just don't get it.
Any help in understanding would be appreciated.