9 Replies Latest reply: Feb 6, 2018 1:33 AM by xxxxx yyyyy RSS

    Resident load

      Hi fnds,

       

      I have a question in my mind that after every resident load do we need to drop that table from where we have extracted.

       

      Sales_T:

      Load * Inline [

      TxnID,Amount

      101,456454

      102,456454

      103,455446

      104,456787

      105,446464

      106,458464

      ];

      Sales:

      Load * resident Sales_T;

      Drop Table Sales_T;

       

      In which case we should go for dropping the table.

        • Re: Resident load
          Vipin Mishra

          for in this case

          if u not use drop table automatically data are double because its automatically concat  the both table.

           

          there is two way to work on this

          1 use no concatenation

          2 drop table

          • Re: Resident load
            Nilesh Gangurde

            Hi,

             

            Whenever you will take the resident load then you have the same data in two tables.

             

            these two tables will consume RAM.

             

            hence to avoid the RAM consumption we need to drop the table.

             

            -Nilesh

            • Re: Resident load
              Naresh Guntur

              Hi Deepthi,

               

              In the above case, if you run the script, you will not get any data. It happens like this.

               

              1. First table will be loaded.

              2. The resident load table(2nd table) will get automatically concatenated to the first table as all the fields are same.

              3. Now when you drop the first table, there will no tables in your data model.

               

              So, now even you drop the table, the purpose is not getting served. Before using resident load, it is always advisable to use noconcatenate if all the fields are same.

               

              The main reason behind dropping the original table is whatever data is required is already there in the second table.

               

               

              Cheers,

              Naresh

                • Re: Resident load

                  Yes Naresh.I got that now.But i took only two tables but in the middile i have same table columns of Sales_T with different data.There i need to do concatenation.but i took that two tables to show an example.But the example was wrong.I got the depth concept by ur reply.

                   

                  Thank you & Regards,

                  Deepthi

                • Re: Resident load
                  neetha P

                  Apart from avoiding Ram consumption and concatenating of tables

                  Its Best practice to clean-up as you go, which avoids loading fields not used in visualization.

                  So list of field to select will be short and user friendly.

                  • Re: Resident load
                    xxxxx yyyyy

                    Sales_T:

                    Load * Inline [

                    TxnID,Amount

                    101,456454

                    102,456454

                    103,455446

                    104,456787

                    105,446464

                    106,458464

                    ];

                    Sales:

                    Load * resident Sales_T;

                    Drop Table Sales_T;

                     

                    In above case we can't remove the Sale_T table. We have to remove the Sales(Parant) table. The Sales_T data will get from Sales table.