Create ETL Process Fact Table

agent86ray / SQL-AGENT-JOB-DATA-MART

This project builds a data mart from the SQL Server Agent tables. It implements an increment load design and includes type 2 slowly changing dimension handling for jobs and job steps.

1 stars 0 forks source link

Create ETL Process Fact Table #1

Open agent86ray opened 4 years ago

agent86ray commented 4 years ago

Create etl schema

Create etl.ExecutionLog table with ETL_RUN_KEY (from sequence), start time and end time