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 with a set of steps they take if any.
4 Replies
akhaliq7 , Remove duplicates. Add Index columns
Watch Video 2,3,4 in this series
https://www.youtube.com/playlist?list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
it already has the duplicates removed and it already has a primary key, Just has too many rows that are not in the fact table
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?
