Re-Using Junk Dimensions

View previous topic View next topic Go down

Re-Using Junk Dimensions

Post  scabral on Tue May 28, 2013 3:09 pm

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

scabral

Posts : 58
Join date : 2012-05-02

View user profile

Back to top Go down

Re-Using Junk Dimensions

Post  hkandpal on Tue May 28, 2013 3:48 pm

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

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Re-Using Junk Dimensions

Post  scabral on Tue May 28, 2013 4:20 pm

thanks Himanshu,

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

scabral

Posts : 58
Join date : 2012-05-02

View user profile

Back to top Go down

Re: Re-Using Junk Dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum