All joins are driven by the first table which is assumed to be the main fact table. It supports joining on up to 50 dimensions. Queries should be designed without join loops and joined in such a way that the joins all flow from the first table or higher level tables.
Example:
SELECT *
FROM b
LEFT JOIN a ON b.id = a.id
Comments
Please sign in to leave a comment.