ETL 010 · Tagetik Application

▾ Data Flow 1 extraction · 6 transformations · 6 loadings

Extractions 1

Database (1)

1 ← dati_note +2

Extract ToBeHired Employees

Staging

→

Transformations 6

Enrichment : SQL instruction ×4

46 ×2

Staging

→

Loadings 6

CPM — Data

01 → DATI_SALDI_LORDI

Load in DATI_SALDI_LORDI

02 → DATI_NOTE

Load in DATI_NOTE

01 disabled → DATI_SALDI_LORDI

Load in DATI_SALDI_LORDI

02 disabled → DATI_NOTE

Load in DATI_NOTE

CPM — Setup

03 → DEST4

Load in DEST4

04 → DEST4_GERARCHIA_ABBI

Load in DEST4_GERARCHIA_ABBI

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 6source
Sources: MAP_IMP_OPERAZIONE
▶

Transformation rules applied to the ETL staging area.

Enrichment : SQL instruction Get MAX EmployeeID GET MAX EMPID

▾

SQL

select MAX(substr(cod_dest4,4,4)) from dest4 where cod_dest4 like 'EE_%' and cod_dest4<>'EE_500'

Ranking type · D

46 Ranking Employee Ranking Employee

▾

SQL

campo5

Ranking type · M

Enrichment : SQL instruction Assign Employee Number Employee Number

▾

SQL

campo8::INT+campo9::INT

Ranking type · D

Enrichment : SQL instruction Hired Employee ID Hired Employee ID

▾

SQL

concat('EE_',LPAD(campo10::text, 3, '0'))

Ranking type · D

46 Rank Hired EmployeeID Ranking Hired Employee ID

▾

SQL

group by campo11

Ranking type · D

Enrichment : SQL instruction Hired Employee Desc Employee Name Generator

▾

SQL

(SELECT a.eledim_input1 ||' '|| B.eledim_output1 as name FROM map_regola_tab_elemento a	CROSS JOIN map_regola_tab_elemento b WHERE a.cod_mappatura='40'AND b.cod_mappatura='40'GROUP BY a.eledim_input1,b.eledim_output1,campo5OFFSET floor(random()*40608) LIMIT 1)

ETL filter

CAMPO13='1'

Ranking type · D

Loadings 6source
Sources: MAP_IMP_SCARICO
▶

Staging data written to Tagetik or other targets.

Tagetik 03 Load in DEST4 Load in Employee Dimension

▾

Target 03 Load in DEST4 → DEST4

Loading policy

Task 1 14 Insert into target table

ETL data filter

Specific · campo13='1'

Origin

M Delete origin records from current routine

Tagetik 04 Load in DEST4_GERARCHIA_ABBI Load Employee Hierarchy - Relationship

▾

Target 04 Load in DEST4_GERARCHIA_ABBI → DEST4_GERARCHIA_ABBI

Loading policy

Task 1 14 Insert into target table

ETL data filter

Specific · campo13='1'

Origin

M Delete origin records from current routine

Tagetik 01 Load in DATI_SALDI_LORDI Load Employee Info - DATI_SALDI_LORDI

▾

Target 01 Load in DATI_SALDI_LORDI → DATI_SALDI_LORDI

Loading policy

Task 1 11 Delete from target table

Task 2 14 Insert into target table

Filter parameters 1 Entity 2 CostCenter 4 HiredEmployeeID

ETL data filter

Specific · campo3 in ('ST_612','ST_500')

Origin

M Delete origin records from current routine

Tagetik 02 Load in DATI_NOTE Load Employee Info - DATI_NOTE

▾

Target 02 Load in 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 4 HiredEmployeeID

ETL data filter

Specific · campo3 not in ('ST_612','ST_500')

Origin

M Delete origin records from current routine

Tagetik 01 Load in DATI_SALDI_LORDI Delete TBH data disabled

▾

Target 01 Load in DATI_SALDI_LORDI → DATI_SALDI_LORDI

Loading policy

Task 1 11 Delete from target table

Target data filter

Specific · COD_DEST4 like 'TBH%'

Origin

A Delete all

Tagetik 02 Load in DATI_NOTE Delete DatiNote Data disabled

▾

Target 02 Load in DATI_NOTE → DATI_NOTE

Loading policy

Task 1 11 Delete from target table

Target data filter

Specific · COD_DEST4 like 'TBH%'

Origin

A Delete all

`010`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 6source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 6source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 1source
Sources: MAP_IMPORT
▶

010

Extractions 1sourceSources: MAP_IMP_ACQUISIZIONE ▶

Transformations 6sourceSources: MAP_IMP_OPERAZIONE ▶

Loadings 6sourceSources: MAP_IMP_SCARICO ▶

Used by Jobs 1sourceSources: MAP_IMPORT ▶

`010`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 6source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 6source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 1source
Sources: MAP_IMPORT
▶