This paper shows how one can create business rules in Warehouse Builder and then apply them to real world ETL problems. The reader will see how changing a business rule will change the ETL logic with a few simple clicks. The paper also shows how one can create error handlers completely driven by business rules. As an extension of the rules in ETL the paper shows how to validate the rules on the actual source data, to ensure the rules are in fact correct and supported by the data. The paper shows how business rules can have a real impact on a developer's life. Maintenance of ETL logic becomes simpler; error routines can be modified in minutes, saving valuable time and effort.
Did you find this white paper useful?
19 out of 47 users found this white paper useful
Related white papers
Enabling Operational Business Intelligence With Real-Time Data Integration Solutions
As organizations continuously expand through technology along with facing a worldwide competition, it is important to be on top of every aspect of your business and markets served. This is...
Real-Time Business Intelligence and Data Integration as a Strategic and Critical Component
This white paper discusses the strategic role that Data Integration plays in achieving Real-time Business Intelligence, with On-Demand access, integration, delivery and usage of enterprise information.
Business Modeling: A New Paradigm for Designing and Implementing Enterprise Data Warehouses
An enterprise data warehouse provides management with information about what is happening in the business. It must present a single version of the truth from multiple perspectives - and quickly...
Unlocking the Potential of Radio Frequency Identification Technology
This white paper from IBM explains how Radio Frequency Identification (RFID) technology can help companies across diverse industries drive down the costs associated with asset and inventory management. The paper,...
Ferplast Improves Service and Maintains Competitive Edge With Data Integration
Ferplast SpA a leading supplier of more than 2,000 pet products, wanted to provide management the ability to reorganize information quickly by classifications in the staging area, and obtain reports...
Ethernet Network-Based DAQ and Smart Sensors for the OPERA Long-Baseline Neutrino Experiment
This paper proposes a data acquisition scheme for the OPERA long-baseline neutrino experiment based exclusively on Ethernet. The expected data rate allows the use of an Ethernet capable device close...
Bank Asya Accelerates ETL Processes by 400%
Bank Asya provides a wide range of banking products and services to retail, corporate and commercial customers in Turkey. Bank Asya wanted to integrate multiple databases to create a single...
