This scenario collects the statistics log for the Job execution and displays it on the Run console. Note that, since the tStatCatcher Statistics check box is not selected for the components, the statistics log applies solely to this specific Job.
Drop tFixedFlowInput, tFileOutputDelimited, tStatCatcher and tLogRow onto the workspace.
Link tFixedFlowInput to tFileOutputDelimited using a Row > Main connection.
Link tStatCatcher to tLogRow using a Row > Main connection.
Double-click tFixedFlowInput to open its Basic settings view.
Click the Edit schema button to open the schema editor.
Click the [+] button to add three columns, namely ID_Owners, Name_Customer and ID_Insurance, of the Integer and String types respectively.
Click Ok to validate the setup and close the editor.
In the dialog box that appears, click Yes to propagate the changes to the subsequent component.
Select the Use Inline Content (delimited file) option.
In the Content box, enter
Double-click tFileOutputDelimited to open its Basic settings view.
In the File Name field, enter the full name of the file to save the statistics data.
Double-click tLogRow to open its Basic settings view.
Select Vertical (each row is a key/value list) for a better display of the results.