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).
You have three sort of fragmentation:
- Fact-based / Dimension-based fragmentation
- Content-based / Value-based fragmentation
- Level-based fragmentation / aggregate navigation
The type data that the fragment does contain must be set.
Fragmented data is data from a single domain that is split between multiple tables (multiple fragment).
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.