ETL 030 · Tagetik Application

▾ Data Flow 1 extraction · 2 transformations · 2 loadings

Extractions 1

Database (1)

30 ← DATI_SALDI_LORDI +1

DATI_SALDI_LORDI - REJECTED

→

Transformations 2

Parameter choice ×1

Enrichment : SQL instruction ×1

Staging

→

Loadings 2

CPM — Data

70 → DATI_SALDI_LORDI

REJECTEDIN - DATI_SALDI_LORDI

60 → DATI_SALDI_LORDI

REJECTEDOUT - DATI_SALDI_LORDI

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 2source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 2source
Sources: MAP_IMP_SCARICO
▶

Staging data written to Tagetik or other targets.

Tagetik 70 REJECTEDIN - DATI_SALDI_LORDI Load - REJECTEDIN Employee Data

▾

Target 70 REJECTEDIN - DATI_SALDI_LORDI → DATI_SALDI_LORDI

Loading policy

Task 1 11 Delete from target table

Task 2 14 Insert into target table

Filter parameters 2 CostCenter 3 Scenario 4 Employee 6 Entity

ETL data filter

Specific · campo10='170'

Target data filter

Specific · cod_categoria in ('170','110')

Origin

O O

Other origins: MAP_30_010

Tagetik 60 REJECTEDOUT - DATI_SALDI_LORDI Load - REJECTEDOUT Employee Data

▾

Target 60 REJECTEDOUT - DATI_SALDI_LORDI → DATI_SALDI_LORDI

Loading policy

Task 1 11 Delete from target table

Task 2 14 Insert into target table

Filter parameters 2 CostCenter 3 Scenario 4 Employee 6 Entity

ETL data filter

Specific · campo10='160'

Target data filter

Specific · cod_categoria in ('160','120')

Origin

O O

Other origins: MAP_30_010

Job	Description	Groups
`050`	EE Transfer Approve/Reject	—
`056`	EE Transfer Reject	—

`030`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 2source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 2source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 2source
Sources: MAP_IMPORT
▶

030

Extractions 1sourceSources: MAP_IMP_ACQUISIZIONE ▶

Transformations 2sourceSources: MAP_IMP_OPERAZIONE ▶

Loadings 2sourceSources: MAP_IMP_SCARICO ▶

Used by Jobs 2sourceSources: MAP_IMPORT ▶

`030`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 2source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 2source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 2source
Sources: MAP_IMPORT
▶