1 Reply Latest reply: Sep 27, 2013 5:10 AM by Christian Conejero RSS

    Data testing

    Gopi Raju

      My source data is coming from oracle,xls,sql server for one single table.

      How to test the output data of report or dashboard if it is pulling right data.

        • Re: Data testing
          Christian Conejero

          Hi.

           

          You can place a field like Source. Filtering by Source you'll know the origin of data.

           

          LOAD

          'xls'                    as "Source",

          *

          from xls;

           

          concatenate

           

          LOAD

          'sql'                    as "Source",

          *

          from sql;

           

          concatenate

           

          LOAD

          'oracle'                 as "Source",

          *

          from oracle;