Toad World Blog

Fact and Dimension tables in Toad Data Modeler

Jun 17, 2013 8:01:00 PM by Vaclav Frolik

In physical model you can define Data Warehouse Type for your tables and graphically distinguish the Fact and Dimension tables.
Example:

tdm-img-234.png-550x0

By default, the Data Warehouse options are not available and must be activated in Settings. 
Standard Entity Properties form:

tdm-img-231.png-550x0

To display Data Warehouse Type options click Settings | Options and in section Physical Model enable the checkbox in group box Form Settings.

tdm-img-232.png-550x0

To set Data Warehouse Type then choose Dimension or Fact value from the Data Warehouse Type combo box.

tdm-img-233.png-550x0

Good luck! 

Tags: Toad Data Modeler Data Modeling

Vaclav Frolik

Written by Vaclav Frolik

Interests:

  • UX design and graphics
  • Databases
  • Product / Project management
  • Web technologies
  • Online marketing

Favorites:

  • Music bands: Pearl Jam, Audioslave, RHCP, Midnight Oil, Alter Bridge...
  • Actors: Kevin, Edward, Jack, Jeff and my kids.
  • Actresses: Kim, Jennifer
  • Sports: MTB, Squash, Football (the one played with feet, not hands)
  • Series: IT Crowd, The Big Bang Theory