This paper provides an approach to implementing one of the more demanding types of transformations: the dreaded Type 2 Slowly Changing Dimension (SCD). Although this technique may be applicable to other type of transformations, it is particularly useful for the Type 2 SCD. The focus of this paper is the Type 2 SCD, as it is the most effective and most commonly used variety. The Type 2 SCD provides an approach for completely and elegantly tracking history, while conforming to the dimensional model for optimal performance. Although Oracle9i Warehouse Builder (OWB) does not have "Built-in" support for SCD transformations, one can easily implement them within the OWB framework.
Did you find this white paper useful?
24 out of 50 users found this white paper useful
Related white papers
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...
MSDN Webcast: geekSpeak Extending SQL Server Integration Services With Reza Madani (Level 100)
The presenter of this webcast shows the tips for extending Microsoft SQL Server Integration Services (SSIS) with scripts. He also takes the questions about the most effective use of this...
Helped Save Reporting and Analysis Costs for IATA Through Centralized Data Warehouse
IATA wanted a system that would consolidate all the E-Ticketing information from various sources and generate specific reports that would show the compliance status and related information of each airline....
The Forrester Wave: Information-as-a-Service, Q1 2008
Forrester evaluated leading enterprise Information-as-a-Service (IaaS) vendors across 94 criteria and found that BEA Systems, IBM, Oracle, and Red Hat have established leadership positions, thanks to their IaaS capabilities, breadth...
Managing Complex XML Data in Oracle XML DB 11g
Over the past few years, XML has emerged as the new standard for data transmission, and its use is becoming more prevalent as companies continue to adopt XML-based solutions. As...
