Attendence/Course work is usually modeled by a methodology called a "Factless Fact Table". It may be appropriate for what you are trying to do.

Here is an article/design tip by the...

What are the top 10 - 20 business questions you are attempting to answer?

Can you attach your target schema? That is, the dimensions surrounding the fact table you are loading along with the fact table itself?

Also, think about what actual "events" you are...

Is this an OLTP-like schema for the Quality Management function of a hospital?

Completely agree: http://www.kimballgroup.com/2001/11/03/design-tip-30-put-your-fact-tables-on-a-diet/

I also forgot. NEVER, EVER, under ANY circumstance, leave null values in your dimension keys. It puts too much at risk for an...

One more thing......in the Microsoft Data Warehouse Toolkit, the actual use of the Lookup Transform is covered more in depth in

ETL Subsystem 13: Fact Table Builders

ETL Subsystem 14:...

I agree.

The Microsoft Datawawrehouse Toolkit, chapter 7, has great tips for loading fact tables along with sample scripts and SSIS packages to go with it. The 2005 version gives you...

No problem.

In our solution we create jobs on the fly and set them to run one second after scheduling the job. By doing this you can still allow the...

This works for us:

1. User must exist in the msdb database.

2. User requires one of 3 roles in msdb database: SQLAgentOperator, SQLAgentReader, SQLAgentUser role.

3. Make sure...

Have you given any thought towards putting together a post on driving the SCD Transform using the "SCD Type" column from the MSDWH Toolkit's spreadsheet. That would be really...

Looks like the perfect tool for following the ETL Standards as outlined by Joy and Warren in chapter 7. Good job 🙂