First solution you can load file to a Temp table then get count of temp table .İf count=0 then send e-mail, else load to your target table.
Use a variable like this=Select count(*) from your_stg_table
or use a variable like this: Select <%=odiRef.getPrevStepLog("INSERT_COUNT")%> FROM dual
Another solution:You can use Jython code to get rowcount of your files before load the table.
Can you please let me know the Jython code to get rowcount of our files before load the table.
Also please confirm me here do we need to follow the above steps when we use jython script in ODI, suppose my file path is C:\source assume. Here what method do I need to follow for this requirement.
steps one by one please for better understanding.