0

I'm completely new to Data Warehousing and Marts and wanted to ask for some advice on the best resources to learn and gain knowledge to start me off on the right path. I have a project to work on but need some guidance or somewhere to start really.

The problem is I've been given a matter of weeks to create a small mart with Fact and Dims then need to write stored procs for a GUI to feed in and out of this. I need to know how to create a scripted SCD which I have a basic idea and can use MERGE scripts.

Bor
  • 775
  • 3
  • 19
  • 44
Andy_RC
  • 81
  • 1
  • 3

1 Answers1

0

I assume you're looking for free resources.

You can start with Kimball Dimensional Modeling Techniques. Check also SCD not easy as 1, 2, 3 and Slowly Changing Dimensions.

Since you need to design Fact tables and Dimension tables would be hepful as well.

Do you have any concrete assignments and if yes, you can show what you've done so far.

Bor
  • 775
  • 3
  • 19
  • 44