Load Zero Byte File
Posted: Mon Oct 19, 2015 2:52 am
All,
I have to load zero byte file into the table whereas the filename and reason as "File is Empty" needs to be loaded into the table.
My Job design is something below
SeqFile --> Transformer --> TeraData Connector
If the Input file is zero byte none of the record will be uploaded into the database.
Simply O Rows will be processed.
But instead, I want to insert a row into the table with FileName and reason as "File is Empty".
How to change the above design to accommodate this logic ?
I have to load zero byte file into the table whereas the filename and reason as "File is Empty" needs to be loaded into the table.
My Job design is something below
SeqFile --> Transformer --> TeraData Connector
If the Input file is zero byte none of the record will be uploaded into the database.
Simply O Rows will be processed.
But instead, I want to insert a row into the table with FileName and reason as "File is Empty".
How to change the above design to accommodate this logic ?