We perform dimensional data modeling, identify star schemas, fact tables, conformed and slowly changing dimensions, bridge tables, aggregate tables, calculated attributes, dimensional hierarchies; load data model to Sparx EA and implement it in OBI Metadata Repository. We also implement data load processes using reverse engineered models, data stores and validations; define projects, configure check, load, and integration knowledge modules; perform data mappings; sequence interdependent transformations into packages execution.
