Skip to content

Pipeline

Structure

flowchart LR
    00.ETL-->01.Staging;
    00.ETL-->03.DWH;

Note that the 02.Transform does not see to be used. It's empty.

eeg-ssis-pipline-overview.png

Staging

The staging pipeline copies data from Postgres Views to the staging database EEG_StagingDB. Steps:

  1. truncate DIM tables (delete the data)

  2. copy dim tables

  3. truncate fact tables

  4. copy fact tables

eeg-ssis-pipline-staging.png

You can click on an activity to see the details:

eeg-ssis-pipline-activities.png

And, again:

  1. in Staging.dtsx

  2. click Odoo Projects to see the source details.

  3. click on Build Query...

  4. to see and select the source column

  5. to see the source view or table

  6. or click on execute to

  7. see the data

eeg-ssis-pipline-source-activity.png