|
|
|
|
|
|
|
by Exforsys.com
|
|
print article · comment on article
|
|
|
previous |
page 3 of 3 |
next |
|
|
|
|
|
Finally tools necessary for query, analysis and reporting on data would have to be built into the system to the process to deliver a rich end user experience. This process is known as Data Presentation.
Users need to understand what rules applied while cleaning and transforming data before storage. This information needs to be stored separately in a relational database called Metadata.
Metadata is “data about data”. Mapping rules and the maps between the data sources and the warehouse; Translation, transformation and cleaning rules; date and time stamps, system of origin, type of filtering, matching; Pre-calculated or derived fields and rules thereof are all stored in this database. In addition the metadata database contains a description of the data in the data warehouse; the navigation paths and rules for browsing the data in the data warehouse; the data directory; the list of pre-designed and built in queries available to the users. For more visualization of this article along with the screen shots and more visit http://www.exforsys.com/content/view/1295/332/
About the Author
Exforsys is a community of developers specializing in C, C++, C#, Java, J2EE, .NET, PeopleSoft, SAP, Siebel, Oracle Apps., Data warehousing, Oracle/SQL Server/DB2 and Testing. Please visit http://www.exforsys.com for more tutorials, http://www.itquestionbank.com for Tech Resources Directory and for Interview questions http://www.geekinterview.com is an open database. |
|
|
|
|
|
previous |
1·2·3 |
next |
|
|