Hi,
From the depths of a corporate office, where I write SQL queries for a living. When I was studying data warehousing and business intelligence - which was eons ago - we had staging tables and the productions tables.
The staging tables consisted of unaltered data. Data directly from source and then you can manipulate data - transform/clean/ standardize it and then load it to the production tables that could be used by business intelligence or knowledge mining teams.
Yesterday I found out that staging tables are now called integration tables in Microsoft-verse. With a slight addition that since there could be various data sources integration tables are used to consolidate the data from all those sources. It was also done earlier, but somehow the powers that be needed to clarify this.
Hope you have a great day.
No comments:
Post a Comment