A Quick Way to Inspect Dimension Loading Behavior
Oracle Warehouse Builder has a powerful operator for Dimension in mapping that supports ROLAP/MOLAP/HOLAP modeling, Slowly Changing Dimension, Orphan management, etc. Although it is easy to use, we developers sometimes really need to know what the exactly behavior of the dimension operator is for our specific source data. Below I’ll introduce a quick way to examine how the dimension operator will behave.
Prepare the scenario
We run the script as shown in Appendix A to set up objects used in our scenario. The script will also deploy the objects. Go to <ORACLE_HOME>/owb/bin/unix, then
./OMBPlus.sh /tmp/create.tcl
Start OWB Design Center, now we have several objects
…click on the title to read the full article…
Leave a Reply