Not able to get the count from database table

Anonymous — Wed, 12 Oct 2016 13:51:09 GMT

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"))"

Can you please assist.

Regards,

Rakesh D

Re: Not able to get the count from database table

Anonymous — Wed, 12 Oct 2016 14:04:23 GMT

tOracleRow will not return you the count. Please use tOracleInput instead to get the count of records from the database.

topic Not able to get the count from database table in Talend Studio

Not able to get the count from database table

Re: Not able to get the count from database table