So we completed a 3 – Sprint DWH
project for a FMCG US based company.
It was a roller coaster ride and we
stretched every bit of our mental and physical skin to deliver.
Technical
Streams: The project had the following technical streams
1.
Data Modeling – The data modelers started off
with their part of analysis and prepared the logical data models of the Salesforce
ERP source system.
a.
The analogous tables were physicalised in the
Oracle relational dbse which was called as the first layer. The business key
was being used as the primary key in this layer.
b.
The second layer was the staging layer where the
dimensional model existed(ODS). Facts and dimensions were identified by the
onsite teams and the same were incorporated in the logical data model and
implemented in the physical data model in the 2nd layer of the
DWH.Here the Surrogate key was the primary key called as the SID or the source
identifier.
c.
The presentation layer (BIDW)was the third and
the final layer which had the warehouse identifier (WID) as the primary key ,
it also had the SID.The tables were a mirror image of their siblings in the ODS
table.
2.
ETL – Informatica 9.6 on Linux was being used
for this project.
3.
Reporting – Cognos 10.1 clients were used.
No comments:
Post a Comment