4 Replies Latest reply: Jun 10, 2014 2:55 AM by Yeo Poh sai RSS

    I have

    Yeo Poh sai

      Hi All

       

      i have 10 QVD file all the same , it work fine for 2 year. Total i create another unqie table when i Concatenate with the 10 QVD file , i the whole database become very slow and not working.

      This new QVD table have all the same field with 10 QVD table. except 1 additional field name i add .I try to use NoConcatenate , it also never help to solve the problem. Can some one give me suggestion ?

       

      PRICE:

       

       

      load * from $(vQVDPath)BECKHOFF.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)HAKKO.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)GE.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)HMS.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)KEB.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)REDLION9.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)SCM.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)KINCO.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)POWER_SUPPLY.qvd (qvd);

       

      // below table create problem.

      noConcatenate

       

       

      load * from $(vQVDPath)LOCAL_TID.qvd (qvd);

        • Re: I have
          Kiran Rode

          Give Table name to 11th table,

           

          Use below script:

           

          PRICE:

           

           

          load * from $(vQVDPath)BECKHOFF.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)HAKKO.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)GE.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)HMS.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)KEB.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)REDLION9.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)SCM.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)KINCO.qvd (qvd);

           

           

          Concatenate

           

           

          load * from $(vQVDPath)POWER_SUPPLY.qvd (qvd);

           

          // below table create problem.

          noConcatenate

          LOCAL_TID:

          load * from $(vQVDPath)LOCAL_TID.qvd (qvd);

          • Re: I have
            Jonathan Dienst

            Paul

             

            If you are adding the last load into a separate table, you are creating a synthetic key with all the fields in the existing table. This will likely have a severe performance impact. Rather concatenate the new table to the existing table. The new field will be null for all the existing sources. You will need to force the concatenation with Concatenate as the field list is not identical.

             

            HTH

            Jonathan

              • Re: I have
                Yeo Poh sai

                Hi All

                 

                Thank you for your advise. but i still unable resolve the issue.

                 

                Enclosed is my 3 QV doc .

                 

                1. first 10 table QVD . ( working fine ).

                2. last table QVD. ( working fine ).

                3. combine of above 2 table ( not working ).

                 

                Paul

                • Re: I have
                  Yeo Poh sai

                  Hi All

                   

                  it was my mistake , in my last table i accidently create a field name Currency_P.

                  in the first 10 table it was created by :-

                   

                   

                  LOAD * INLINE [

                  Currency_P, RATE_P

                  SG, 1

                  MY, 2.65

                  INDO, 9500    

                  THAI, 25

                  ];

                   

                  So my last table field name force the whole table Currency_P = INDO

                   

                  I manage to find out when I try to create Local Product Table for MY , same thing happen , then i know where i make the mistake.

                   

                  Thank you , now i can move on.

                   

                  Paul