SCD with no Fact

View previous topic View next topic Go down

SCD with no Fact

Post  3ilabsbiz on 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

3ilabsbiz

Posts : 1
Join date : 2010-11-23

View user profile

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