ETL 040 · Tagetik Application

▾ Data Flow 1 extraction · 1 transformation · 4 loadings

Extractions 1

Database (1)

40 ← dati_note +1

DATI_NOTE - PENDING

→

Transformations 1

46 ×1

Staging

→

Loadings 4

CPM — Data

110 → DATI_NOTE

PENDING - DATI_NOTE

120 → DATI_NOTE

TOBEAPPROVED - DATI_NOTE

170 → DATI_NOTE

TRANSFER FROM DATI NOTE

100 → DATI_NOTE

PENDING STATUS - DATI_NOTE

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 1source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 4source
Sources: MAP_IMP_SCARICO
▶

Staging data written to Tagetik or other targets.

Tagetik 110 PENDING - DATI_NOTE LOAD PENDING

▾

Target 110 PENDING - DATI_NOTE → DATI_NOTE

Loading policy

Task 1 11 Delete from target table

Task 2 14 Insert into target table

Filter parameters 1 Entity 2 CostCenter 3 Scenario 4 Employee

Target data filter

Specific · cod_categoria='160'

Origin

M Delete origin records from current routine

Tagetik 120 TOBEAPPROVED - DATI_NOTE LOAD TOBEAPPROVED

▾

Target 120 TOBEAPPROVED - DATI_NOTE → DATI_NOTE

Loading policy

Task 1 11 Delete from target table

Task 2 14 Insert into target table

Filter parameters 5 Entity Transfer To 2 CostCenter 3 Scenario 4 Employee

Target data filter

Specific · cod_categoria='170'

Origin

M Delete origin records from current routine

Tagetik 170 TRANSFER FROM DATI NOTE LOAD TRANSFER FROM

▾

Target 170 TRANSFER FROM DATI NOTE → DATI_NOTE

Loading policy

Task 1 11 Delete from target table

Task 2 14 Insert into target table

Filter parameters 5 Entity Transfer To 2 CostCenter 3 Scenario 4 Employee

ETL data filter

Specific · campo31='1'

Target data filter

Specific · cod_categoria='170' and cod_conto='ST_465'

Origin

M Delete origin records from current routine

Tagetik 100 PENDING STATUS - DATI_NOTE LOAD PENDING STATUS

▾

Target 100 PENDING STATUS - DATI_NOTE → DATI_NOTE

Loading policy

Task 1 11 Delete from target table

Task 2 14 Insert into target table

Filter parameters 1 Entity 2 CostCenter 3 Scenario 4 Employee

ETL data filter

Specific · campo31='1'

Target data filter

Specific · cod_categoria='010' and cod_conto='ST_455'

Origin

M Delete origin records from current routine

`040`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 1source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 4source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 1source
Sources: MAP_IMPORT
▶

040

Extractions 1sourceSources: MAP_IMP_ACQUISIZIONE ▶

Transformations 1sourceSources: MAP_IMP_OPERAZIONE ▶

Loadings 4sourceSources: MAP_IMP_SCARICO ▶

Used by Jobs 1sourceSources: MAP_IMPORT ▶

`040`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 1source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 4source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 1source
Sources: MAP_IMPORT
▶