Last week, I passed my final exam to acquire the MCSE BI, I would like to share with you this feedback especially on my preparation for all the exams, this is not a strict guideline of course, but it is is just what was best for me.
The MCSE certification consists of taking 5 separate exams: the first 3 give you the MCSA SQL Server certification:
We always talk about STG and ODS in BI archi, so what is the role of these two phases in a BI archi?
- STG (Staging Area): is a set of tables which represent a true copy of the data source and which are purged each time the ETL is run: it is a waiting area, a “boarding room” before the ODS phase; it is in these tables that we can find data in bizarre formats.
- ODS (Operating Data Store): is the place where the transformations, the crossings,… etc; before the power supply of the data warehouse and which uses the STG as a source.