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 ...
Hello camargos88
Thank you for your response.
Tables are from our ERP via ODBC. I tried append but refresh takes forever.
Is there any other solution, until append is fix.
Regards,
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