Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SCD with no Fact

Go down

SCD with no Fact Empty SCD with no Fact

Post  3ilabsbiz Tue Nov 23, 2010 1:09 am

I have a typical scenario to analysis No. of Account based on Zipcode.

We have in OLTP the following tables
1. Account ( AccountId, Account Number, Account Attributes)
2. Contact ( ContactId,AccountId, contact attributes)
3. Address ( AddressId,ContactId,Address type, Zipcode, city, state,country)

Q1. Could you please guide me/point to how I can keep track of Address changes in DW and count the Account no based on ZipCode in the cube on a monthly /daily basis

Q2. I created a link table between Account and Address with ( AccountKey,AddressKey) and Address as SCD type 2 with 5 columns to track end/start date,current flag, reason etc. but how to link the date as dimension in this scenario.

Thank you in advance for your time and consideration


Posts : 1
Join date : 2010-11-23

Back to top Go down

Back to top

- Similar topics

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