compare the records and load into Oracle DB

[Anonymous]

Hi Everyone,

I have metadata file in whcih records are as follows:

Filename count

x 50

y100

etc..

Now,i have to insert all the files into oracle DB and from metadata file i need to compare record counts with the DB.

I need to write a Talend Job which take only count from the metdata file and compare it with record counts of Oracle DB.

I know it will be easy if i write java code or use some tpivot thing.But still is there any straight forward solution.

Please let me know how to proceed with it.

Regards,

Mohit

[Anonymous]

Hello,

The tFlowMeterCatcher component catches the processing volumetric from the tFlowMeter component and passes them onto the output component.

For example:
tFileInput--->tFlowMeter--->tOracleOutput
tFlowMeterCatcher---tLogRow
There is one column called "count" in the schema of tFlowMeterCatcher which counts the no. of records pass by the specify flow.
Let me know if it is OK with you.

Best regards

Sabrina