Hi , I want to know the count of database table once data is loaded into database table. here is my workflow:
tFileInputExcel-->tMap-->tOracleOutputBulExec
| trigger--if subJob Ok | tJava (here I want to know the count of excel sheet and the database table and will store into 2 context variables separately and then I will put a RunIf condition (if both variable match then execute the next process otherwise send an email stop the process)
I am able to get the count of excel sheet "((Integer)globalMap.get("tFileInputExcel_1_NB_LINE"))" but not able to get the count of database table ( I tried OracleRow and wrote a query "select count(*) from db_table" but getting null in the global variable "((Integer)globalMap.get("tOracleRow_1_NB_LINE_INSERTED"))"
