Forum Discussion
Please advise on the ideal data structure when multiple business processes are included in a single
What you are trying to do is SCD2, and is NOT how SFDC does things. In SFDC you have an Object Field History table instead.
SCD2 is not a bad approach for what you are trying to do. All you need is a distinct record identifier and a "Modification Date" column.
Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses (sqlshack.com)
Super UserWhat you are trying to do is SCD2, and is NOT how SFDC does things. In SFDC you have an Object Field History table instead.
Apologies, you are right; SFDC was not relevant.
Does it make sense to transform the table structure into a more ideal format in the database before loading it into Power BI? If so, what kind of structure would be best?
- lbendlin
SCD2 is not a bad approach for what you are trying to do. All you need is a distinct record identifier and a "Modification Date" column.
Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses (sqlshack.com)
For example, separating the table by status.