Dimension attribute values may change constantly over the time. (Say for example customer dimension has customer_id,name, and address) customer address may change over time.
How will you handle this situation?
There are 3 types,
1) To overwrite the existing record,
2) To create additional new record at the time of change with the new attribute values.
3) To create new field to keep new values in the original dimension table
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment