Using Reject Data Browser
In the map, after the connection is established with the data if you click
, the
Target Data tab displays the following information at the bottom:
• Reject data file path and file name.
• Reject data in table format with column headings as Record Name, Field1, Field2, Field3, and so on.
Note: If the connection is cleared, then the
is disabled.
You can do the following:
• From the Page Size drop-down list, select the required number of entries to be displayed per page.
• Next to Page, use the arrow icons to go to the first page, previous page, next page or last page, or type a value to go to a particular page.
• Click the small arrow icon on the top-right corner of the Target Data tab and you can do any of the following:
– Click Find to search for a particular word in the reject data. The searched text is highlighted in the Target Data tab.
– Click View Options and you can select either of the following to:
• Collapse All - Collapse the tree view for Hierarchical data or Hybrid <All Records> selection.
• Expand All - Expand the tree view for Hierarchical data or Hybrid <All Records> selection.
Note: These two options are disabled for a flat file.
– Click Data Format and select one of the following:
• Formatted - This is the default option.
• Masked
• Text/Hex Mix
• Hex
Date Browser displays the data based on the type of reject file. They are:
• Single Record - Flat File/Table with no SQL - Displays a simple view with no left navigation.
• Multi record flat file - By default <All Records> is selected on the left. If you click a particular record, the details of only that record is displayed on the right.
• Hierarchical data - Displays the records as a tree view on the left. By default, <All Records> is selected in the tree view. You can choose a specific child node by expanding the parent records. When viewing the parent level records, the fields are arranged vertically. When viewing the child/node level records, the fields will be arranged horizontally.
• Hybrid data - Displays the records as tree view on the left. By default, <All Records> is selected in the tree view. You can click and choose a specific record.
Note: All records are displayed if the Query source is defined as table/ view while defining the connection.
• SQL/Table data - Displays the list of tables in the database on the left. By default, the connected to table is selected.
Note: SQL query (statement or file) data is displayed under the <SQL> table name.