Supported and unsupported joins
Specific join types, join predicates, and join combinations are supported by Informix® Warehouse Accelerator.
Supported joins
Equality join predicates, INNER joins, and LEFT OUTER joins are the supported join types.
The fact table referenced in the query must be on the left side of the LEFT OUTER join.
Any filter on a dimension table that you use in a LEFT OUTER join must be a post-join filter. A post-join filter is in the WHERE clause after the join.
Unsupported joins
The following joins are
not supported:
- RIGHT OUTER joins
- FULL OUTER joins
- Informix outer joins
- Joins that do not use an equality predicate
- Subqueries