Dave Mason on Nostr: Question for my #PowerBI/#Data friends. A developer created a table that isn't ...
Question for my #PowerBI/#Data friends.
A developer created a table that isn't normalized. A PBI service *somewhere* syncs/pulls that data. There's 15 million rows, and it takes a long time.
Does normalization apply here? I told the dev to change 6 VARCHAR columns (all repeating values) to INTs, which would be Foreign Keys to 6 lookup tables. They should be syncing INTs instead of various strings, right?
A developer created a table that isn't normalized. A PBI service *somewhere* syncs/pulls that data. There's 15 million rows, and it takes a long time.
Does normalization apply here? I told the dev to change 6 VARCHAR columns (all repeating values) to INTs, which would be Foreign Keys to 6 lookup tables. They should be syncing INTs instead of various strings, right?