2 Replies Latest reply: Sep 1, 2016 7:01 PM by Rocco Rocco RSS

    Problem loading data from Microsoft DWH

      Hi,

      I have a problem during the extraction from dwh.

      I noticed that if I load data and store them in local, in the qvd file some code, like 175, 0175 and 00175, are stored all like '175'.

      Cause I have write an automatic script for having a staging area 1:1 with DWH, there is a way for doing it without auto-traslation of data-type?

       

      Thanks

        • Re: Problem loading data from Microsoft DWH
          Marco Wedel

          Maybe using

           

          Text(field) as field

           

          in the load?

           

          regards

           

          Marco

          • Re: Problem loading data from Microsoft DWH

            Thanks Marco for your reply.

            Maybe you could  have  reason but...it's not so now, sorry.

            You are not thinking in the automatic script.

            I need to staging 138 tables...do you think really the right way is writing 138 load instructions checking for each table what is the field I have to translate and what no?

            Well now seriously, the ONLY  working way is a preceding load on an extraction from DWH.

            I am writing a script with variables for checking from a list the fields I have to translate.  So the script check if the field is in the table or not, modifying loading script according to the situation.

            Someone have a better idea for this case,  please?

            Thanks to all