Multiple keys for one dimension

[justcotto]

I have a few fact tables that I have concatenated.  In these tables I have multiple WIDs that join to a single dimension.  I was wondering what would be the best way to handle this situation. 

Table_Name	Column_Name	Condition
WC_PURCH_RCPT_F	BUSINESS_UNIT_WID	W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_F	BUSINESS_UNIT_PO_WID	W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_F	BUSINESS_UNIT_GL_WID	W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_F	BUSINESS_UNIT_PC_WID	W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_F	OPERATING_UNIT_WID	W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_F	PURCH_DEPT_WID	W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_F	GL_ACCOUNT_WID	W_GL_ACCOUNT_D using ROW_WID
WC_PURCH_RCPT_F	PROJECT_WID	W_PROJECT_D using ROW_WID
WC_PURCH_RCPT_F	PURCH_LEGDER_WID	W_LEDGER_D using ROW_WID
WC_PURCH_RCPT_F	PURCH_SUPPLIER_WID	W_PARTY_D using ROW_WID
WC_PURCH_RCPT_F	OPERATOR_WID	WC_OPERATOR_D using ROW_WID
WC_PURCH_RCPT_F	RECEIVED_ON_DT_WID	AHS_DW.W_DAY_D  using ROW_WID
WC_PURCH_RCPT_F	JOURNAL_DT_WID	AHS_DW.W_DAY_D  using ROW_WID
WC_PURCH_RCPT_F	ACCOUNTING_DT_WID	AHS_DW.W_DAY_D  using ROW_WID
WC_PURCH_RCPT_F	PURCH_ACCOUNTING_PERIOD_WID	W_MCAL_PERIOD_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT1_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT2_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT3_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT4_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT5_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT6_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT7_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT8_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT9_WID	W_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_F	GL_SEGMENT10_WID	W_GL_SEGMENT_D using ROW_WID

[marcus_sommer]

Maybe a transforming per The-Crosstable-Load would be useful.

- Marcus

[Brett_Bleess]

Justin, did Marcus' post help you with things, or are you still trying to figure things out?  If Marcus' idea worked, please be sure to give him credit by using the Accept as Solution button on his post.  If you are still trying to figure things out, please leave an update for us.

Regards,
Brett