摘要 |
A database is a central source of data for query and analysis. Functions of a database include retrieving, analyzing, transforming, loading and managing data; making them available for further use. Disclosed herein is a method for improved data input into a database whilst maintaining the structure of metric of facts. Data is extracted from a data source (1), transformed and loaded into fact tables in a data warehouse by means of bridge tables. Automation of dynamically adding dimensions into multiple fact tables with respect to the data source (1) is disclosed in the present invention. |