I have a logical model that is relational and propagate/cascade the keys from one table to next and so on.
There are relationships in the model with 7-10 compounded keys because of this propagation.
I would like to use one column to be the key, such as a "surrogate key", foreign key to the next entity and the subsequent entity would not get propagated with compounded key.
what are the steps I need to convert this relational model to dimensional?
Entity1(Entity1_PK, attribute1, attr2, ... attrN)
Entity2(Entity2_PK, Entity1_PK, attributes...)
Entity3 ( Entity3_PK, Entity2_PK, Entity1_PK, attributes) <- compounded keys
PK stands for primary key column.
Desire dimensional outcome:
Entity2(Entity2_PK, Entity1_FK, attributes...)
Entity3 ( Entity3_PK, Entity2_FK, attributes) <- compounded keys
FK stands for foreign key column.
Hello. I think these steps will be helpful:
Powered by IDERA