Simple data loader - File & DB Compare

One Star

Simple data loader - File & DB Compare

Hello,
Talend newbie - inherited a system and need to make some changes.
The job takes an XLS file and inserts into a staging table in DB. I need to modify the job so it compares the file and table size and alerts if all data in file is not in the table.
I know there is a tFileProperties component, can get the file size into a global variable etc, but not sure how I can do a compare of the 2. 
What is the easiest way to do this?
Thanks,
valli
Moderator

Re: Simple data loader - File & DB Compare

Hi,
Have you tried to compare the total number of  proceed records to see if all data in file has been inserted into DB?
Usually, we use Nb_LINE  is used to count the total number of records have been proceed.

When inserted item is choosen, there will be a global variale such as ((Integer)globalMap.get("t<DB>_1_NB_LINE_INSERTED")) will be avaible, which counts the total number of records have been inserted into database.


Best regards


Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.