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.
my bad for writing late at night.
Entity3 ( Entity3_PK, Entity2_FK, attributes) <- no compounded keys, just one primary key and one foreign key.
I'm watching this one with interest. ER/Studio allows you to draw dimensional models but doesnt offer much automation for conversion from one to the other. This is really the realm of our sister tool WhereScape which we just released an integration with. Would you like to see more automations for creating warehouse models?
Hello. I think these steps will be helpful:
Powered by IDERA