A translatable JoinTree must have one of the following forms:
- FactTable join DimTable
- DimTable join FactTable
- FactTable join JoinTree(of Dim table joins)
- JoinTree join FactTable
- joinPlan join DimTable
- DimTable join joinPlan
The last 2 forms provide the recursion that enables any kind of JoinTree: lefty, righty or
bushy.
A Join is translatable if:
- it is a valid star join
- the Dimension Table projection and filters are translatable.
- for JoinTrees, it must validate for the Facttable's StarSchema
A translatable JoinTree must have one of the following forms: - FactTable join DimTable - DimTable join FactTable - FactTable join JoinTree(of Dim table joins) - JoinTree join FactTable - joinPlan join DimTable - DimTable join joinPlan
The last 2 forms provide the recursion that enables any kind of JoinTree: lefty, righty or bushy.
A Join is translatable if: - it is a valid star join - the Dimension Table projection and filters are translatable. - for JoinTrees, it must validate for the Facttable's StarSchema