Data warehousing - What is real time data-warehousing?

What is real time data-warehousing?

The combination of real-time activity and data warehousing is called real time warehousing. The activity that happens at current time is known as real-time activity. Data is available after completion of the activity.

Business activity data is captured in real-time data warehousing as the data occurs. Soon after the business activity and the available data, the data of completed activity is flown into the data warehouse. This data is available instantly. Real-time data warehousing can be viewed / utilized as a framework for the information retrieval from data as the data is available.

What is real time data-warehousing?

In real time data-warehousing, the warehouse is updated every time the system performs a transaction. It reflects the businesses real time information. This means that when the query is fired in the warehouse, the state of the business at that time will be returned.
Data warehousing - What is conformed fact? What is conformed dimensions use for?
What is conformed fact? What is conformed dimensions use for? - Allowing having same names in different tables is allowed by Conformed facts......
Data warehousing - Define non-additive facts
Define non-additive facts - The facts that can not be summed up for the dimensions present in the fact table are called non-additive facts......
Data warehousing - Define BUS Schema
Define BUS Schema - A BUS schema is to identify the common dimensions across business processes......
Post your comment