Hi,

I am busy going through the Microsoft official curriculum for 'Designing and Implementing OLAP solutions' and the online tutorial.

Is Foodmart 2000 an OLTP, datamart or data warehouse?

I just think I am missing an important part in creating the Fact Table. This seems like the more important task when creating cubes. Would this be covered in a data warehousing module?
When is this created and where can I get some documentation about creating it. I just dont think it is part of a normal relational database design or development.

Any help?



Regards

Ian



If Everything Seems To Be Going Well, You Have Obviously Overlooked Something.