Forum Discussion
Setup Incremental refresh on Many to Many relationship table
Hi All, I have model where relationship between DIM & FACT is Many to Many , I have used bridge table to reslove m:m issue converting it to M:1:M , but i had to bring all the columns from FACT to...
amitchandak But the below statement from Microsoft docs contradicts with incremental refresh works for many to many , because it expects to have unique values in 1 side of the table , which mean many to many will always fails the above condition.
Hi All
I am facing some issue with incremental refresh,
I have data of 50k in fact table, when i apply icremental refresh its coming 25 lakhs.
Fact table having multiple joins with different tables,
from each table we are fetching updated date and again among all which is max date taking that , on that incremental refresh is apllied, please any one help me wnything wrong i am doing, why that much duplicate records i am getting