Staging data written to Tagetik or other targets.
Target
140
TRANSFEROUT - DATI_NOTE
→ DATI_NOTE
Loading policy
Task 1
11
Delete from target table
Task 2
14
Insert into target table
Filter parameters
5
Entity Transfer To
2
CostCenter
3
Scenario
4
Employee
Target data filter
Specific · cod_categoria in ('190','160')
Origin
O
O
Other origins: MAP_30_040
Target
130
TRANSFERIN - 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
3
Scenario
4
Employee
Target data filter
Specific · cod_categoria in ('180','170')
Origin
O
O
Other origins: MAP_30_040
Target
180
APPROVED/REJECTED - DATI_NOTE
→ DATI_NOTE
Loading policy
Task 1
11
Delete from target table
Task 2
14
Insert into target table
Filter parameters
2
CostCenter
3
Scenario
4
Employee
5
Entity Transfer To
ETL data filter
Specific · campo12='ST_455'
Target data filter
Specific · cod_conto='ST_455' and cod_categoria='010'
Origin
T
Delete manual origin record
Target
190
TRANSFERRED - DATI_NOTE
→ DATI_NOTE
Loading policy
Task 1
11
Delete from target table
Task 2
14
Insert into target table
Filter parameters
2
CostCenter
3
Scenario
4
Employee
5
Entity Transfer To
ETL data filter
Specific · campo12='ST_450'
Target data filter
Specific · cod_conto='ST_450' and cod_categoria='010'
Origin
T
Delete manual origin record