7 Replies Latest reply: Mar 3, 2018 10:52 AM by Thiago Justen Teixeira RSS

    Concatenate resident table

    Michael Simonsen



      In my load script I want to concatenate a previously loaded table to my one fact table. The scripts principle goes like this:


      Load *

      From table1 ;

      Concatenate FACT:

      Load *

      From table2;

      Concatenate FACT:

      Load *

      From table3;

      // Now I need to first load table4 without concatenation, and make some calculations i table4



      Load *

      From table4;


      At the end I now want to include Table4 in my FACT.

      I have tried:


      Concatenate FACT:

      Load *

      Resident Table4 ;

      Drop Table Table4;


      But it does not work. I lose all variables from table4

      Any ideas?


      Regards Michael