The execution history for a job that has at least one Reconciliation task will have an additional Report column. It has a link to a Reconciliation Report.
While the execution history provides details for the job execution, the reconciliation report provides information about the data being reconciled in a reconciliation task steps.
The summary displays the reconciliation results at a high level. It shows if there are any discrepancies overall between the two data sets. This report is can be exported into Excel.
Click on the report link for a job run to view the Reconciliation Report Summary.
The Reconciliation Report Summary will display the following columns:
Loome Integrate V5.2 provides the ability to view reconciliation results side by side for easier comparison. The detailed report drills down on the results from the summary report. It shows the actual comparison figures. This report is can be exported into Excel.
Click on a task or step in the Summary report, then click on Open Report.
The filter option allows for narrowing down of the reconciliation results.
The available filter options are:
You can use the drill down feature in Loome Integrate to expand an aggregated sum in the detailed report. Click on an underlined value to see the breakdown of that figure.
All errors between the source and target data sets are highlighted in red.