Dear All,

Thank you for your comments. I will be getting rid of the NULL values and reducing the size of my int(s) pronto!

I have Amazoned the MS Data Warehouse Tookit and should get it by the end of the week.

In the meantime I have attached data schematic that I would like to convert to dimensions. I am trying to monitor compliance rates based on Topic and Job. A specific job will need to do specific topics. I will then need to slice by Organisation hierarchy.

As I need to delve in to each individually I can't put the topics (e.g. Consent or Dementia) all under one roof so to speak.

The relationship is centered on the Delegate / staff member, hence the link. Based on the business requirement matrix I have worked out who does what.

I have tied this to each topic using the Delegate table PK as FKs in almost all the other tables.

This is where I am encountering problems.

When I try to upload the individual PK into the Fact Table in SSIS I am getting a lot of No Match Outputs. Perhaps (actually I am pretty sure) I am doing the LookUp incorrectly.

I am using the DelgateID as the LookUpSource. Should I be using something else? Is it because of the NULLS in the Dimension tables or a combination of both?

Am I completely on the wrong track here?! Thoughts very welcomed.

I am quite eager to learn and willl readily start over again if general concensus is to do so.

Be brutal if you must in a kind way!!

Regards,

Marvin.