Time is one of the most powerful dimensions a data warehouse can support. Unfortunately it’s also one of the most problematic. Unlike OLTP environments that focus on only the most current versions of reference data, DW environments are often required to present data not only as it currently exists, but also as it previously existed. Implemented correctly, a data warehouse can support several temporal orientations, the three most common being “current,” “point-in-time,” and “periodic.” Implemented incorrectly, you will create a solution that will be impossible to maintain or support.

Key Points

  • Many organizations from an array of different business sectors have been exploiting the time element of their Data Warehouses for true strategic advantage the past couple of decades.
  • Providing true temporal support has implications on your organization’s logical data models, physical database designs, as well as your data maintenance & navigation architecture and directly relates to the tools that are available.
  • Understanding these techniques and challenges are crucial to enabling a temporal capability.
  • Historically, developing this capability has been achieved through brute force and though use of traditional SQL (non-temporal) data definition and manipulation language constructs.
  • Learning how Teradata’s new temporal DBMS features including the period data type as well as the associated DML operators and functions can help you more effectively develop a time-related data repository and applications and ultimately create value for your organizations more quickly.

Presenter: Greg Sannik, Principal Consultant - 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: Data Warehouse Architects/Designers, Data Warehouse Administrators, Data Warehouse Modelers, ETL Administrators, BI/Application Developers

Course number 46085
Training URL http://www.teradata.com/t/ten/
Format Recorded webcast
Price $195.00
Credit hours 2.00