Forum Discussion

CJ_96601's avatar
CJ_96601
Icon for Helper V rankHelper V
6 years ago

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 ...
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi 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_96601's avatar
    CJ_96601
    Icon for Helper V rankHelper V
    6 years ago

    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, 

     

     

     

     

     

     

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      CJ_96601 ,

       

      Are you using import or direct query ?