Updating olap dimensions
A star schema is built in a database in order to enable faster retrieval from the database.
The query is run over a select set of data rather than over an OLTP setup.
By default all attributes are related to the key attribute, so define attribute relationships wherever applicable.In spite of the importance of ETL processes, little research has been done in this area due to its complexity.There is a clear lack of a standard model that can be used to represent the ETL scenarios.Extraction–transformation–loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, its cleansing, customization, reformatting, integration, and insertion into a data warehouse.Building the ETL process is potentially one of the biggest tasks of building a warehouse; it is complex, time consuming, and consumes most of data warehouse project’s implementation efforts, costs, and resources.
Search for updating olap dimensions:
The Aggregator transformation is unlike the Expression transformation, in that you can use the Aggregator transformation to perform calculations on groups.