Archives of the TeradataForum

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

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

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>>