Hi, all is their any Reconciliation concept in TOS. for eg. Bank reconciliation: Bank reconciliation is the process of comparing and matching figures from the accounting records against those shown on a bank statement. The result is that any transactions in the accounting records not found on the bank statement are said to be outstanding. Taking the balance on the bank statement adding the total of outstanding receipts less the total of the outstanding payments this new value should (match) reconcile to the balance of the accounting records. Bank reconciliation allows companies or individuals to compare their account records to the bank's records of their account balance in order to uncover any possible discrepancies. Discrepancies could include: cheques recorded as a lesser amount than what was presented to the bank; money received but not lodged; or payments taken from the bank account without the business's knowledge. A bank reconciliation done regularly can reduce the number of errors in an accounts system and make it easier to find missing purchases and sales invoices. thanks in Advance.
For bank rec. you need to use a finance/accounting software for this. For the general concept of reconciliation I think it is too specific for a general purpose ETL tool and very difficult to implement with a row-based tool.
Talend is a Java code generator for data integration and ESB programs. Reconciliation is the process to validate the data. Tests or validation must be done with test data for input and proven output data. Like in any other normal development you have to design and setup tests.