Hi All
I am trying to create data model diagram(s) for several data marts that are already existing in Data Warehouse database. My goal is to eventually publish the diagrams for our users in the intranet.
- Oracle 12c database
- All tables are either Facts or Dimensions following the Star Schema design
- Tables have primary keys
- Foreign keys are not enforced at the database level. There are not foreign keys.
- We do not currently use any Data modeling tool to generate a DDL. And it is not my goal at this point to use a data modeling tool for generating DDL. We create DDLs manually.
What I have done so far..
I imported a fact and couple of dimension tables from the Oracle data warehouse into Datamodeler. WC_OCCUPANCY_F is fact table. W_DAY_D and WC_UNIT_D are dimension tables. The red arrows are what I want to generate. Below is the screenshot of this.
My Question:
Is there a way setup a script or template with "rules" for foreign key so the Datamodeler can draw the relationships in the diagram?
My rules would look like:
Table name ending with _F is a Referred Table
- Foreign Key rule would use a combination of Referrencing table Name and naming convention we are following on the FKs. I can write a generic rule that catches most of them. And, create any exceptions manually.
- Table name ending with \_D is a Referrencing Table
- column called ROW\_WID is the PK
Thank you
Neil
Message was edited by: orawin2. I removed the reference to mit website to avoid confusion.