I am building out a data vault & specifically working through when to breakout a satellite table into sub-satellite's by attributes that change at a different rate
That being said, I only have the modified date at the record level ie when any attribute change was made, not a modified date by attribute.
Any advice on how to write a query against a table do tease out frequency of change by attribute?
I am thinking something along the lines of group the attribute by business id & count the number of distinct attribute values... but wouldn't boolean values through that off?
