Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Maybe a transforming per The-Crosstable-Load would be useful.
- Marcus
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