Posts
In a project, more often than none that it is desired to join a dimension table to a fact table based on certain conditions instead of a direct join.
For example, I have a time dimension table that keeps two calendar codes and we only want the data that its calendar code is '001' to be matching with the data in the fact table, otherwise for certain product or location, it's measure would be counting both calendar code.
Now before we proceed, let's...
