Article sur l’architecture de données BI, bon pour remettre les bases à plat.
I’ve done ETL design and development in both integration projects and in reporting environment.
In master data integration projects, it’s not hard to distinguish staging area from the target area. In the staging area, truncating tables with old data and loading new data is a pretty common practice. I’ have not seen any truncating tables in the target area. This is a good thing. It means that developers understand the role of staging, and understand that loading data into target area needs to be carefully designed, or “reconciled”, as a consultant called it. Depending on the business rules, we will end up either creating new records in the target, or updating existing records, or deleting obsolete records.
In the reporting environment, however, developers have very different attitude and very different understanding of staging VS. target.
This is a very typical architecture I’ve seen so far. The flaw in this design…
View original post 315 mots de plus