Forum Discussion
Solved
Please advise on the ideal data structure when multiple business processes are included in a single
I am envisioning a data structure similar to that of Salesforce (SFDC). For instance, consider a table where multiple statuses are stored, as shown in the table below. In a sales process, for examp...
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)
lbendlin
Super User
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?