Forum Discussion
CJ_96601
Helper V
Helper VDATA 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 ...
camargos88
Community Champion
Community ChampionHi CJ_96601 ,
Can't you just use 1 Emp table (append them)...
Also, why do you need those 3 tables, once you have the data on table 1 ?
Ricardo
CJ_96601Helper V
Helper VHello 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,
- camargos88
- CJ_96601
- camargos88
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