
Discover how a data warehouse serves as a central repository that integrates disparate data sources using an ETM tool, staging areas, target areas, and datamarts for analysis and reporting.
Explore Teradata database administrator roles, detailing application dba tasks like creating databases, users, roles, and access, plus system dba duties on software installation and system monitoring.
This tutorial is intended to give an overview on, What is Data warehouse, Why we need Data Warehouse, Components of Data Warehouse, Difference between Operational Database & Data Warehouse DataBase, Difference between Data Warehouse DataBase & DataMarts.
Next it focus on Teradata Database, Where does Teradata come in Data Warehouse Architecture, Who use Teradata.
Later in the tutorial we will cover details on Teradata Developer roles and responsibilities.
And Classification of Teradata Database Administration along with Roles and Responsibilities of Application DBA & System DBA.
Important Note: