Please enable JavaScript.
Coggle requires JavaScript to display documents.
Guide lines -Data Transformations (AT EDW (Aggregates/Sums/Snapshots,…
Guide lines -Data Transformations
AT SOURCE
Group by,
Order by, Sum, etc
Business Logic
Transformations
Transformation for filtering
Delta data from single source
AT EDW
Aggregates/Sums/Snapshots
Dimensional Modeling
3NF Data
Do not use to feed
Downstream apps
Use exclusively for Reporting
AT EAI
(Enterprise Integration Layer)
Do not perform any Business Logic
transformations
Transformation of
Multisource at same granularity level
Transformation
if enhancing data from
Multisource
Transformation for filtering delta data
from multi-source
AT REPORTING
Transformation specific to
Reporting only
Do not use to feed downstream apps
AT API Layer
Transformations if
enhancing data from multi-source
Business logic
transformations