Multivalued Dimensions - Group Tables and ETL
Posted: Wed Apr 08, 2009 4:18 am
Hi,
I'm refining a dimensional model that includes several multivalued dimensions at the grain of the fact.
Has anybody implemented the ETL surrounding helper / group tables surrounding mutlivalued dimensions as although I am still in the knowledge assimilation phase, I'd like to get a grasp on the potential complexities that are involved as I have not implemented a multivalued dimension structure before. I would therefore appreciate any views from anyone who has been there before and any advice / design tips.
Many Thanks,
Daren
I'm refining a dimensional model that includes several multivalued dimensions at the grain of the fact.
Has anybody implemented the ETL surrounding helper / group tables surrounding mutlivalued dimensions as although I am still in the knowledge assimilation phase, I'd like to get a grasp on the potential complexities that are involved as I have not implemented a multivalued dimension structure before. I would therefore appreciate any views from anyone who has been there before and any advice / design tips.
Many Thanks,
Daren