Archives of the TeradataForum
Message Posted: Thu, 01 Nov 2001 @ 23:03:50 GMT
Subj: | | Data Model with Microstrategy as frontend tool |
|
From: | | Krishna Lakshminarayanan |
As is wellknown, Microstrategy prefers Snowflake and NCR advices 3rd normal form (neither star nor snowflake) ...
Has anyone worked on a 3rd normal form Datawarehouse with Microstrategy as a frontend tool?
My question is typically aimed at Aggregated tables and MSTR's capability in handling them correctly. MSTR cannot handle pure Star
models and return wrong data when aggregated
If anyone has successfully worked with MSTR and a 3rd noraml Teradata DW - could you please throw more light on how you modelled in
MSTR
regards
|