Routines 1 source
Code
Description
Extractions
Transformations
Loadings
010
Store Management
1
—
3
ETL Dimensions 8 source
Semantic mapping of staging fields (CAMPO1…CAMPO130) to functional meanings within this domain.
Dimension codes appear in operation input/output and lookup table definitions.
Code
Description
Acronym
Type
Identity
Usages
1
Store Code
SC
S
—
4 usages
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
Output
Output Target
→ COD_DEST1
001
003
009
2
Store Description
SD
S
—
3 usages
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
Output
Output Target
→ DESC_DEST10
001
→ DESC_DEST11
001
3
Store Type
ST
S
—
2 usages
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
Output
Output Target
→ COD_DEST1_ELEGER
003
4
Comments
CM
S
—
1 usage
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
5
Status Change
SS
S
—
2 usages
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
Output
Output Target
→ COD_DEST1_ELEGER
009
6
Effictive Date
ED
S
—
1 usage
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
7
Scenario
SE
S
02
1 usage
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
8
Entity
EN
S
01
1 usage
▾
Type
Field role
Code
Src.fmt
Source Format
Input field
010
Parameters 3 source
Domain-level parameters available as {P_xxx} tokens in filter expressions.
Code
Description
Type
Multi-select
Related dimension
Source detail
Usages
010
Scenario
Tagetik
—
7
Scenario
SCENARIO.COD_SCENARIO
1 usage
▾
Type
Field role
Code
Extr.
Routine — Extraction
Filter param
010 #10
020
Entity
Tagetik
—
8
Entity
AZIENDA.COD_AZIENDA
1 usage
▾
Type
Field role
Code
Extr.
Routine — Extraction
Filter param
010 #10
030
Store
From imported data
Yes
1
Store Code
From imported data
2 usages
▾
Type
Field role
Code
Load.
Routine — Loading
Filter param
010 #11
010 #12
Source Formats 1 source
Scripts
Enriched
Input data formats read by extractions in this domain.
Code
Description
Type
Fields
010
Existing Stores
Database
8
▾
DB type Q
Database query
SELECT TESTO_1,TESTO_2,TESTO_3,TESTO_4,TESTO_5, DATA_1, COD_SCENARIO, COD_AZIENDAFROM FORM_DATIWHERE COD_PROSPETTO='TR_030' AND COD_SCENARIO={010} AND COD_AZIENDA={020}
Field mapping
#
Dimension
Database column
1
Store Code
TESTO_1
2
Store Description
TESTO_2
3
Store Type
TESTO_3
4
Comments
TESTO_4
5
Status Change
TESTO_5
6
Effictive Date
DATA_1
7
Scenario
COD_SCENARIO
8
Entity
COD_AZIENDA
Output Targets — Tagetik 4 source
Tagetik tables written by loadings in this domain.
Code
Description
Target table
Fields
001
Store Info
DEST1
3
▾
Target column
Update
Source — dimension or value
Aggregation
COD_DEST1
By dimension
1
Store Code
Group by
DESC_DEST10
By dimension
2
Store Description
Group by
DESC_DEST11
By dimension
2
Store Description
Group by
003
Store Type
DEST1_GERARCHIA_ABBI
4
▾
Target column
Update
Source — dimension or value
Aggregation
COD_DEST1
By dimension
1
Store Code
Group by
COD_DEST1_ELEGER
By dimension
3
Store Type
Group by
COD_DEST1_GERARCHIA
By value
030
Group by
ORDINAMENTO
By value
0
Group by
007
Comments
DATI_NOTE
0
▾
No field definitions extracted.
009
Status Change
DEST1_GERARCHIA_ABBI
4
▾
Target column
Update
Source — dimension or value
Aggregation
COD_DEST1
By dimension
1
Store Code
Group by
COD_DEST1_ELEGER
By dimension
5
Status Change
Group by
COD_DEST1_GERARCHIA
By value
020
Group by
ORDINAMENTO
By value
0
Group by
No lookup tables for this domain.
Routine
Loading
Table / Object
010Store Management
001Store Info
DEST1
010Store Management
003Store Type
DEST1_GERARCHIA_ABBI
010Store Management
009Status Change
DEST1_GERARCHIA_ABBI