This presentation explains how to physically implement a classic Star design with central fact table surrounded by several de-normalized dimension tables on Teradata.

Key Points:

  • Choosing the primary index columns for the fact table
  • Exploiting AJIs
  • Columnar Tables
  • What to do when no primary index choices look optimal
  • Slowly Changing Dimensions

We assume that you already have some Teradata physical design knowledge before taking this session.

Presenter: Steve Molini - Teradata Corporation

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Audience: Those with a role of Database Administrator (DBA), Data Modeler, ETL Developer, Application Developer, Programmer, Performance Analyst, or Data Warehouse Architect.

Course number:26536
Training URL:
Format:Recorded webcast
Credit hours:2.00