Skip to end of banner
Go to start of banner

ETL+ Objects

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

Introduction and Navigation (Blue Belt Training)

These are the data tables in the DataSelf SQL Data Warehouse. The data is loaded from the Source to the Data Warehouse when the ETL+ refresh process runs.

The first Data Warehouse group is the ERP data loaded into the SQL Data Warehouse tables.

Contrast: Database Objects in MS SQL Server

https://support.microsoft.com/en-us/office/video-get-to-know-database-objects-020bfb91-394e-4555-84a4-5b0fd673e6d6

create database and schemas where all our tables and other objects will reside.

What are the 5 important objects of database?

Database objects

  • Tables.

  • Constraints.

  • Indexes.

  • Triggers.

  • Sequences.

  • Views.

  • Usage lists.

  • No labels