Re-Using Junk Dimensions

[scabral]

I created a junk dimension for an insurance dimensional model to hold policy status information.

The table has 3 columns:

Policy Category (New, Renewal)
Policy Type (Bound, Quote)
Policy Status (Cancelled, Issued, Quote)

so there are a total of 12 rows in the which is every combination of the fields above.

I have 1 fact table that uses all three fields so i was able to do a lookup on each value above to get the correct row.

I now have another fact table that only has the Policy Category field in the source, but does not use the Policy Type or Policy Status field.

How can I do a lookup to just get the Policy Category value that I need without getting multiple rows? I'm using SSIS to load the fact table and lookup steps to find the correct row from the dimension table.

thanks
Scott

[hkandpal]

Hi,

one way could be you could have NULL for Policy Type or Policy Status field or you could have the value 'NA' for Policy Type or Policy Status field.

thanks

Himanshu

[scabral]

thanks Himanshu,

I will create another row with N/A for the fields that are not used. This should do the trick.

[Sponsored content]