Usually, there is a situation where one may need additional columns in the CDM that are not part of the current standard. This is particularly important when customers are used to data that may not be part of the standard. Is there any guidance regarding best practices to do so?
Given that any source data (in our case Clarity) contains possibly hundreds of columns in the source tables, How is the community dealing with this? Are we bringing as many columns as possible or are we selecting a subset?
The other option is linking back to source tables, which I call a reversed ETL. I believe this is a considerable effort. Had anyone has some experience with this?