Forum Discussion
DATA MODEL
Hello, I have 4 facts table and have this model as follows: Table 1 Key Index - Emp No - Hire Date - Termination Date Table 2 ...
CJ_96601 ,
Why don't you submit a query to your source like:
TABLE 1 UNION ALL TABLE 2 UNION ALL TABLE 3....
Also, check this link, maybe it's gonna help with your model:
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Ricardo