Forum Discussion
Cleaning a dimension table correctly
What is the steps required to clean a dimension table that is sourced from a relational database. The dimension table I am referring to contains more rows than my fact table. Can someone provide me w...
You might need to run the Trim and Clean transformations (under Transform -> Format in the ribbon) before removing the duplicates to make sure there aren't any rogue spaces which will not be picked up when removing duplicates. Aslo beware of how the values are spelt: capitals and lower case are treated as different values in Power Query
After removing duplicates
Otherwise, create a new one?
my question is related more towards matching the number of rows in my dimension table to my fact table just want to know what the best practices someone had suggested in another forum to use an inner join in the data source