This topic has been locked.
6 replies Latest Post - 2012-12-20T12:45:02Z by smithha
Pinned topic Tables Rows Count
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
how do you suggest to perform Rows count comparison between two tables?
Updated on 2012-12-20T12:45:02Z at 2012-12-20T12:45:02Z by smithha
Re: Tables Rows Count2012-12-19T13:33:04Z in response to SystemAdminThe simplest way is to create a rule for each table such as FieldX Exists and bind that to the key field. Each rule will generate statistics for Total Records and Total Rows Met (those should generally be equal on a key field).
Then create a Metric that compares the Total Records for table1 and the Total Records for table2. Assuming either one could be higher than the other a good Metric expression would be: *ABS(ruleA Total Records - ruleB TotalRecords) *
Include a Benchmark for the Metric so that you can indicate what variance, if any, you tolerate.
For more on logic for Metrics see: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r7/topic/com.ibm.swg.im.iis.ia.quality.doc/topics/dq_functions_syntax_metrics.html
Re: Tables Rows Count2012-12-20T07:44:46Z in response to smithhaHi Smithha,
When invoking IA Metrica (Metric name "rcc") from Linux using IAJob.sh script but getting the following error message:"Executable not found : rcc"
See the full log from linux:
root@ispardev IAJob_Script# /DataStageInst/IBM/InformationServer/ASBNode/bin/./IAJob.sh -user iadmin -password ***** -isHost ispardev -port 9080 -run ACT_DWH_DEV rcc
-> executing task '-run' with projectName = ACT_DWH_DEV, executableName = rcc
Executable not found : rcc
-user iadmin -password ***** -isHost ispardev -port 9080 -run ACT_DWH_DEV rcc
ETL Team Leader
Re: Tables Rows Count2012-12-20T12:45:02Z in response to SystemAdminTry running the IAJob.sh with the command: -lexecutables project_name
That should list all the available executables in your project so that you can confirm whether "rcc" is listed there or not. If it is there, then I'd recommend contacting customer support to help resolve the issue.