Thanks Guys!

I will get back to you.

Thanks Drew for the comments!

If I had to design the Junk dimension with these values, what do you suggest.

What would be Junk Dimension structure?

Logic: I was thinking about CROSS JOIN.

Any...

Thanks Guys for the quick response!

Looking at the target table structure, I could see that Cross Join doesn't fit. That's where I was confused.

I will try with the EAV approach...

These are the possible values:

SubscriptionStatusSubscriptionStatus

4Contract End

3Contract Cancelled

1Contract Made

2Contract Start

CustomerStatusCustomerStatus

1Customer Start

2Customer End

PaymentCodePaymentDesc

1Settled Late

2Settled On Time

3Invoiced

4Past Due

5Not Invoiced

-1N/A

DocumentTypeDocument

0Blank

1Payment

2Invoice

3Credit Memo

4Finance Charge Memo

5Reminder

6Refund

CaseTypeCaseType

0Unknown

1Car

2Alarm

3Home

4Security

TransportedTocategoryIdTransportedTo

0N/A

1Non agreement garage

2Place of work or business

3Auto Salvage / Car Junk Yard

4Home...