The practice of modeling data prior to a data warehouse implementation has long been a pillar of Teradata best practices. Yet the value of this practice is often questioned by those looking for shortcuts.

Some have a physical model on a different database and want to port it unchanged to Teradata Database to avoid impact to existing applications. Others see modeling as an expensive, time-consuming exercise that is more academic in nature and removed from practical realities. Rather than reprising best practices in data modeling techniques, this session will focus on calling out the risks of NOT modeling. Using case studies and real-world examples, this session will drive home the importance of revisiting modeling decisions prior to a Teradata migration.  And it will highlight practical steps to achieving a high-performance, robust warehouse. We will also explore some of the enabling features within the Teradata DBMS that help accelerate the performance of well-modeled databases.

Note: This was a 2012 Teradata Partners Conference session.

Presenter: Thomas Manfredi, Principal Consultant – Teradata

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: Data Warehouse Architect/Designer, Data Warehouse Modeler

Course number:50595
Training URL:
Format:Recorded webcast
Credit hours:1.00