Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 02 Nov 2001 @ 17:44:01 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020