There is a great deal of confusion over the meaning of data warehousing. Simply defined, a data warehouse is a place for data, whereas data warehousing describes the process of defining, populating, and using a data warehouse. Creating, populating, and querying a data warehouse typically carries an extremely high price tag, but the return on investment can be substantial. Over 95% of the Fortune 1000 have a data warehouse initiative underway in some form.
customer requires automation testing data
company could have three Customer Name entries in its various source systems, one entered as IBM , one as I.B.M. , and one as International Business Machines . Obviously, these are all the same customer. Someone in the organization must make a decision as to which is correct, and then the data cleansing tool will change the others to match the rule. This process is also referred to as data scrubbing or data quality assurance . It can be an extremely complex process, especially if some of the