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.