Data testing

[#1]

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.

[christian77]

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;