Lesson 5: FactTable and the “-i” command line usage

We’ve learned to create dimensions and use simple foreign keys in previous lessons. Now it’s time to learn creating a FactTable. Although the FactTable shown here is simple, you can expand it to customize your own complex fact tables easily. The content of TestFactTable.xml is as below: <?xml version=”1.0″ encoding=”utf-8″?> <Vulcan xmlns=”http://tempuri.org/vulcan2.xsd”>     <Fact Name=”TestFactTableA”…


Lesson 4: Dimension samples and foreign keys

Dimensions and fact tables are the basis of the data warehouses you’re going to create. In this lesson, we’ll see how 2 demo dimensions are created, and how a foreign key is created. It isn’t uncommon that dimensions and fact tables are referencing foreign keys from other dimensions and tables. Using Vulcan, this step will…