I am in the process of creating a data model for the below scenario there will be two hierarchies a) dept hierarchy (emp -> team -> dept -> branch) b) sales hierarchy (emp -> marketing manager -> ...
I've been reading about dimensional models, and in particular fact tables, but I haven't really seen one in action (i.e. the actual content), just diagrams of the table structures and column names ...
The website URL of http://www.ca.com appears in every fact group (subject area) of our Erwin file. How can we make a global change to this URL in Erwin, so we don't have to update each subject area ...
I need to write a data warehouse diagram. I've got a problem with staff area. I have to store a information about workers details like name, age etc., and workers job time and agreement details like ...