DWH - Data Integratie & kwaliteit

Introduction This is the story of a ‘blue’ and a ‘green’ hospital …

IntroductionIn information technology, migration is the process of moving from the use of one operating environment to another operating environment. Moving to a different environment is considered a migration because it involves taking steps to ensure that current applications continue to work in the new environment and making sure that new features are exploited. Migration can involve moving to new hardware or new software or both.

Informatica Informatica is an independent company providing data-integration software and services. Founded in 1993, Informatica employs more then 1.400 employees and has more than 3.000 customers worldwide, including 91 of the Fortune 100 companies.

Introduction Data quality is an often underestimated topic within data warehouse & business intelligence solutions.   Most companies are content in their belief that their data is good enough, although they have no factual basis for that belief. It takes facts to change their minds into a more correct awareness: ‘I had no idea the problem was that large'. An undertaking of improving data quality or getting insight into the data quality provided, should answer amongst other the following questions;

Extraction, Transformation & Loading : often expensive ! ETL or the art of extracting, transforming and loading data is a key process in developing and maintaining a data warehouse, the foundation for sound Performance Management. It can however be an expensive process: not only because it requires a lot of resources and state of the art hardware, but also because the well known ETL-tools from IBM, Informatica, SAS or SAP/Business Objects do not come cheap.