Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
How do load the script for these 2 tables to avoid synthetic keys. I have tried adding a month table, a provider table and a measure table. I keep getting this error; One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will be cut by setting one or more tables as loosely coupled.
this is my first request for help..I'm stuck, please advise.
I have 2 tables - first table
month provider
201808 provider01
201809 provider02
second table
201808 provider01 measure01
201809 provider01 measure02
I also want to have a way to use a monthyear like aug 2018 that pulls data from both tables for the monthyear selected.
Table1:
month provider
201808 provider01
201809 provider02
Table2:
month provider_t2 measure
201808 provider01 measure01
201809 provider01 measure02
Changing the header un the Table2 you don't have the synthetic key.