I need to match the datasets with multiple rule matching cycle with different rules.
Rule1: A.refno=B.refno && A.amt= B.amt && A.trancdate=B.trandate && A.tranno=B.tranno
Rule2: A.remark=B.remark && A.amt= B.amt && A.trandate=B.trandate && A.tranno=B.tranno
Rule3 : A.postingdate=B.postingdate && A.amt= B.amt && A.tranno=B.tranno
Total no of records compared and matched record count and unmatch record count against each rule. Also need to upload unmatched and matched data into oracle table.