Search results for query: *

We always use surrogate keys when creating new fact and dimension tables. We had some old tables and ETL code around that didn't use them, and we haven't got around to retrofitting. As far as I can tell, surrogate keys started to turn up around 1997 - 98, though I really haven't done an...

SQL Server Enterprise Manager includes a diagramming tool. It isn't as good as ERwin or other full-featured ERD tools, but it is included. In SQL Server 2000, expand the Enterprise Manager tree to display the contents of the database. Right-click the Diagrams folder and select New Database...

The dimensions contain PKs which should be unique (they also should be surrogate keys, but that's another story). Since users would (usually/hopefully) access the fact table by constraining on one or more dimensions, the fact table only needs to have a FK for each of the dimensions. Hope this helps.

What technology does company A use to build the data cube? If it is SQL Server 2000, you should be able to use Crystal for reporting on the cube.

What technology is the data cube implemented in? BTW, Holos is a multidimensional tool used to create and report on cubes. You probably wouldn't need Holos if you have a 3rd party tool in place. Crystal Analysis Professional is included in Crystal Enterprise. Crystal Analysis Professional can...

Who am I to conradict the master? ; ) mossback

The Data Warehouse Toolkit (mine was written in 1996) has a lot more detail on dimensions and fact tables than the Data Warehouse Lifecycle Toolkit. To me, the DWT was very helpful in building the dimensional model (closer to the tables and indexes), while the DWLT served as the model for...