DSXchange

Hi the below rule col0="orange" and col1="apple" and col2 ="fruits" output ==== shopname, col0, col1, col2 xxxx,orange, apple, fruits xxxx,orange, apple, fruits yyyy,orange, apple, fruits yyyy,orange, apple, fruits yyyy,orange, apple, fruits produces a list of all the r...

thanks stuart.. will try that

hi ray, thanks for responding, the problem is, i'm trying to translate the below query into a rule, but i'm getting different row counts query ===== select count(1) from table1 where col1 is null and col4 = 'orange' and column_a between 1 and 9 and col2 = "apple" Data rule ====== if ( trim...

hi thanks for all your response, my issue / requirement is to produce the output in a "Report" not just as a file using datarule stage, executing individual rule set becomes too tiresome and it takes a long time, i thought of using rule sets, but i couldn't get outputs for individual rules...

Hi how to specify in the rule definition to find range operation for a data source? for example if i want to find whether a column "column_a" has values in the range between "1 to 9" i tried( column_a >=1 and column_a < 10 ) and column_a matches_regex '[1- 9]' both are not workin...

how do i see the stats of individual rules, when i run with rule set, the only report seems to be giving the stats for rule set is "Rule set execution History Statistics", but this doesn't give it on individual rules, just a total percentage/value of data meeting the rules and not meeting ...

yes, i can able to see when i generate the rule set, but are we not supposed to see the "view test results" in rule set definition

Hi .. any idea.. please?

thanks
MJ

No, I'm having the suite access role. i'm able to see for other data rule definition and data rules, and i tried with one rule set, even after the job get successfully completed, that button is not enabled, very strange....

any other reasons?

Hi I wrote a rule set definition, the definition completed successfully and i can even see the logs in datastage director log and in iasServer-server1.log file as below, but the "view test results" button is not enabled at all after the job, i have ran this several times, but no change... ...

thanks a lot stuart

can you please give some more information on generating customizable reports from command line, where can i find the informations

thanks
MJ

Hi I'm generating the "Data Rule Execution History Summary" report based on a data quality rule written, i'm getting the rule logic and rule binding for every variable its there in the rule, after the execution type section, but i'm not seeing this in the report template specified in the m...

Hi
I'm having trouble running the IA jobs, the iauser doesn't have the privilege to create or drop tables in IADB, may i know what role the iauser should be
assigned in the IADB?

MJ

thanks a lot Robert..

i thought whoever sees the this thread in future will get a full over overview of the IADB...

pointed noted.. will do it ...thanks