Create a dimensional data model

Cancelled

Опис

Requirement to convert a relational data model into a dimensional model based on standard Kiball design techniques.

There are 43 tables in the source model.

Source model comes from InfoSys Finacle which is a cloud based banking system.

Tables are not entirely 3nf as there is some consolidation during the source extract performed by Finacle.

The source model is best described as an Operational Data Store (ODS).

Your job is to convert the source model into dimensions and fact tables and produce an ERD and "create table" scripts.

Attached is an image of the source model ERD and a document describing the requirement.

Included are rules and guidelines for producing the model as well as complete metadata for all 43 tables.

Applicants should have extensive dimensional modelling experience in a banking environment with Finacle experience strongly preferred.

Feel free to ask questions.

Навички: Обробка даних, Організація сховищ даних, Керування

Показати більше: dimensional model data asia erwin, requirements model data process reporting functional system, model data entry outsourcing company profiles ppt, model data entry outsourcing company profiles, linear model data projects, free create onepage brochure describing companys structure business model culture, extract data excel create report, data entry create accounts getafreelancer, create page bochure describing companys structre business model culture, create onepaged brochure describing companys structure business model culture, create onepage brochure describing companys structure business model culturewrite 750word paper apa format describing structure , create onepage brochure describing companys structure business model culture , create onepage brochure describing companys structure business model, create 1page brochure describing companys structure business model culturewrite 750word paper apa format describing structure bu, create document mysql data, scrape data web create excel getafreelancer, scrape data web create excel, car model data free, car makes model data, free car model data, car model data, create page brochure describing companys structure business model, auto model data, mysql data php create dynamic graphs

ID проекту: #12655210