Roelant Vos

Data solution design patterns, implementation, and automation

Category: General

Mapping generation for Data Vault demo: part 3 (staging area) 0

General

Mapping generation for Data Vault demo: part 3 (staging area)

Right now we’ve got the basics for the mapping generation in order: source data and a configured Oracle Warehouse Builder project. The next step would be to generate the staging area based on the source definitions. First we need to import the source definitions metadata so OWB has something to work on. The source definitions can be imported as source definition metadata to the 00_SOURCE_SYSTEM_WORLD module. The scripts will use this source folder to select the initial...

0

General

Mapping generation for Data Vault demo: part 2 (setting up OWB)

Now that the source data set has been created and is available it is time to initially set up the Oracle Warehouse Builder environment. As mentioned earlier, I’ve chosen OWB for this demo because of the powerful scripting capabilities (TCL / OMB). For the demo environment to work with the supplied scripts you have to place them in the C\:TCL directory because some scripts call other scripts as some sort of include statement. To create...

New design pattern added 0

General

New design pattern added

I’ve added the design pattern (004) which includes the basic ETL ground rules. The architecture section is also almost completed (as a draft I mean). This means that all the basics are present to start the mapping generation testing.