Category Archives: DW

Oracle: Partition by List – Example

The following post will walk you trough an exercise of creating a partitioned table, using the list partitioning, populating and testing the partition pruning. Please note I will also post the scripts at the end of the post, so you … Continue reading

Posted in DW | Tagged , , , , , , , | 2 Comments

Slowly Changing Dimensions – explained

Overview In discussing Slowly Changing Dimension, the first thing you must consider is first of all, your attributes type. Base on this, you will have various SCD types or combination of types. Dimension Attribute Types: Type 0: dimension attribute that … Continue reading

Posted in DW | Tagged , , , , , | Leave a comment