DW - Data Warehousing & Modeling
Alerts and notifications refer to any automated signals or short messages that may be sent through a SMS, an email or an indicator in a dashboard or report. They are a call to action after a specific event has occurred. They are also used to assign tasks or inform the recipients about certain urgent issues. Alerts can be the result of the outcome of a report or specific queries.
SAP HANA is an in-memory database platform for processing high volumes of operational and transactional data in real-time.
It is the ability to determine when a particular process will take place in the future, with special consideration on resource availability, activities, and time constraints.
The Structured Query Language uses a classic English keyword-oriented set of commands to query, describe, manipulate, and manage data.
Testing ETL projects - used for Extracting data, Transforming it according to reporting requirements and Loading it into the data warehouse - is very complex because of many reasons. Typically huge amounts of data are handled and data comes often from multiple sources that need to be combined. Sometimes, the data is loaded incrementally, sometimes it needs to be reloaded in full. These ETL-flows can also apply all kinds of complex calculations and transformations on the data.