Re: Question regarding view

From: sim <jmenker_at_muenster.de>
Date: 21 Apr 2006 00:13:51 -0700
Message-ID: <1145603631.787919.116940@e56g2000cwe.googlegroups.com>

Hallo Mangood,

why don't you just create a second fk relationship to the same dimension table? This way you don't need a second physical dimension table or a view. A view won't help you anyway. If you do that you've got two different foreign keys in your fact table pointing to the same dimension table but possibly to different rows in that dimension table. This is especially meaningful with different time dimensions.

Regards,

Jörg Received on Fri Apr 21 2006 - 02:13:51 CDT