 |
 |
Archives of the TeradataForum
Message Posted: Fri, 02 Nov 2001 @ 17:44:01 GMT
| Subj: | | Re: Data Model with Microstrategy as frontend tool |
| |
| From: | | Dave Ahnell |
I agree with these comments, but being pretty new to Teradata, but not data warehousing, the various modeling techniques, and the
OLAP tools frequently being used to access them, I have a question.
Given that you're using one of these typical data access tools that work better with a dimensional model, and that customers do
often tend to understand these types of models and tools pretty well, why would you implement the 3rd normal form model and then put
a "starish overlay" on top of it? I understand that Teradata works optimally with a 3rd normal form, but if the data access tool has
to access the "overlay" objects, it seems like a lot of extra effort, and I'm wondering for what benefit.
I'd also be curious, Dave, as to what you did to "radically restructure your data" to get it to perform with BO. Did you
accomplish this totally on the database side (views, etc), or in combination with the ETL tool.
| |
