ETL 020 · Tagetik Application

▾ Data Flow 1 extraction · 2 transformations · 2 loadings

Extractions 1

Database (1)

20 ← DATI_SALDI_LORDI +1

DATI_SALDI_LORDI - APPROVED

→

Transformations 2

Enrichment : SQL instruction ×1

Parameter choice ×1

Staging

→

Loadings 2

CPM — Data

50 → DATI_SALDI_LORDI

TRANSFERIN - DATI_SALDI_LORDI

40 → DATI_SALDI_LORDI

TRANSFEROUT - 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 50 TRANSFERIN - DATI_SALDI_LORDI Load - TRANSFERIN Employee Data

▾

Target 50 TRANSFERIN - 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 6 Entity 4 Employee

ETL data filter

Specific · campo10='170'

Target data filter

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

Origin

O O

Other origins: MAP_30_010

Tagetik 40 TRANSFEROUT - DATI_SALDI_LORDI Load - TRANSFEROUT Employee Data

▾

Target 40 TRANSFEROUT - 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 6 Entity 4 Employee

ETL data filter

Specific · campo10='160'

Target data filter

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

Origin

O O

Other origins: MAP_30_010

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

`020`

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
▶

020

Extractions 1sourceSources: MAP_IMP_ACQUISIZIONE ▶

Transformations 2sourceSources: MAP_IMP_OPERAZIONE ▶

Loadings 2sourceSources: MAP_IMP_SCARICO ▶

Used by Jobs 2sourceSources: MAP_IMPORT ▶

`020`

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
▶