Oracle Fusion Analytics allows joining between facts and dimensions in semantic model tables, which are usually defined as Normal Joins. These join conditions are simple comparisons using the "=" operator, for instance, Fact.columnA=Dimension.columnB. Sometimes you must perform more complex joining conditions.