This content has been marked as final. Show 1 reply
Hi,1 person found this helpful
From the guide "A key property of a logical join is cardinality. Cardinality expresses how rows in one table are related to rows in the table to which it is joined. A one-to-many cardinality means that for every row in the first logical dimension table, there are 0, 1, or many rows in the second logical table. The Administration Tool considers a table to be a logical fact table if it is at the Many end of all logical joins that connect it to other logical tables"
It really matters when you specify the driving tables if left hand side has less reocrds than right hand and makng it as driving table by menitoning the cardinality