I'm trying to use join multiple tool with dimension table that I have and Fact table, the problem is after using join multiple I'm getting rows with null value except one column.
I'm gonna explain my case using example:
I joined using these two columns that are match to each other but the problem is I'm getting one more row that all fields are null except that one BelongTo that located in Dimension table.
The real rows' number was: 73,701
after Join: 73,702
Why I'm getting extra rows? how can I remove these extra column? how does the join operation process? As I know it should check the equality between these two columns.