ETL 010 · Tagetik Application

▾ Data Flow 1 extraction · 6 transformations · 1 loading

Extractions 1

XLSX (1)

Upload File

Staging

→

Transformations 6

Enrichment : SQL instruction ×4

Enrichment : lookup table ×1

SQL Check ×1

Staging

→

Loadings 1

CPM — Data

010 → DATI_SALDI_LORDI

Upload into main Table of Facts

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 6source
Sources: MAP_IMP_OPERAZIONE
▶

Transformation rules applied to the ETL staging area.

Enrichment : SQL instruction TGK ACCOUNT Set Corporate CoA

▾

SQL

case when campo15 is NULL then campo4 end

Ranking type · D

Enrichment : lookup table Local GL to Corporate CoA Mapping

▾

Lookup table · 01

Ranking type · D

Enrichment : SQL instruction Error Message Check for non-mapped accounts

▾

SQL

CASE WHEN CAMPO15 NOT IN (SELECT COD_CONTO FROM CONTO)THEN 'CCH TAGETIK ACCOUNT MISSING'ELSE NULLEND

Ranking type · D

SQL Check Non-mapped account warning

▾

ETL filter

campo15 not in (select cod_conto from conto)

Ranking type · D

Enrichment : SQL instruction Scenario Scenario Setup

▾

SQL

CONCAT(CAMPO1,'ACT')

Ranking type · D

Enrichment : SQL instruction Currency Assign Currency

▾

SQL

SELECT COD_VALUTA FROM AZIENDA WHERE COD_AZIENDA = CAMPO3

Ranking type · D

`010`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 6source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 1source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 1source
Sources: MAP_IMPORT
▶

010

Extractions 1sourceSources: MAP_IMP_ACQUISIZIONE ▶

Transformations 6sourceSources: MAP_IMP_OPERAZIONE ▶

Loadings 1sourceSources: MAP_IMP_SCARICO ▶

Used by Jobs 1sourceSources: MAP_IMPORT ▶

`010`

Extractions 1source
Sources: MAP_IMP_ACQUISIZIONE
▶

Transformations 6source
Sources: MAP_IMP_OPERAZIONE
▶

Loadings 1source
Sources: MAP_IMP_SCARICO
▶

Used by Jobs 1source
Sources: MAP_IMPORT
▶