About
The fragmentation (known also as partitioning) is the most powerful feature of OBIEE. You can fragment (or partition) any logical table (fact table as dimension table) in more than one logical table source (LTS).
For the same logical table, you may have more than one logical table source (or physical table as one logical table source is always mapped to only one physical table).
You have three sort of fragmentation:
- Fact-based / Dimension-based fragmentation
- Content-based / Value-based fragmentation
- Level-based fragmentation / aggregate navigation
Articles Related
Fragment
A fragment is a logical table source that does not contain the entire set of data at a given level.
The type data that the fragment does contain must be set.
Fragmented data
Fragmented data is data from a single domain that is split between multiple tables (multiple fragment).
Type of fragmenation / partition
Fact-based / Dimension-based fragmentation
The logical table sources have different columns:
Content-based / Value-based fragmentation
The logical table sources have different rows (content):
Level-based fragmentation / aggregate navigation
One table source is a natural of compiled aggregate table from an other. It has then a different grain.
Complex
You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.