2 ms·
Does it make sense to coalesce them away in a view? I thought most analysts are given star schemas implemented by views or ETL'd data anyway.
by paulryanrogers 7y ago
Does it make sense to coalesce them away in a view? I thought most analysts are given star schemas implemented by views or ETL'd data anyway.
- mwexler 7y agoDepends on the level of sophistication of the analyst, and if nulls have a meaning or value to the result. Also, at a certain point, knowing that nulls are present gives you yet another measure of dq: not knowing if they are present and hidden vs. visible and countable can be the difference between a wrong answer vs. just an uncertain one.