In the logical model, when I draw a one-to-many relationship between a DIM and a FACT, it does not bring the PK of the DIM into the FACT; I am hand-typing the PKs into the FACT. Is there a plan to fix this ? There seems to be a lack of modeling logic .

Claire Frankel 5 years ago updated by Jarosław Błąd (CEO) 4 years ago 2

Please see Header above, and there seems to be a lack of modeling logic in the Vertabelo Logical Modeler. PKs should migrate from DIM to FACT when the one-to-many relationship is drawn. Also we should be able to convert seamlessly from a logical model to an initial physical model. Please send instructions. Thank you.

Best regards,

Claire Frankel


Under review

Hello Claire,

Thank you for asking this question. In Vertabeblo this behavior was done intentionally (by design). In Vertabelo logical model we combine two different design approaches: conceptual and logical modelling. It is users decision what style is closer to their design needs. We wouldn't like to introduce three different layer of design/diagramming known from such tools like the Sybase Power Designer. It would be too complicated for the most of our users. However we plan to introduce new feature that allow to generate physical model from logical model, where foreign keys will be automatically generated and added to physical design.

If you have any other questions, don't hesitate to contact us. Any feedback is highly appreciated.

Best regards,