How do you handle Type 2 Dimensional Tables
Hi, what is the best way to creating a relationship between a Type 2-Dimensional table and a fact table. Should this be addressed at the data ingestion stage into the lake house or at the Source level, Is current=1? or can it be addressed at the semantic layer. Because M:M permissible as expected but not 1:M which is what is required. A goal in mind not to lose historical data as well