Browsing Target Data
In a map, you can browse the target data after you select the Target Connection, specify the Source File/URL and Properties. To browse the Target Data, perform one of the following:
• On the
Target tab, click
.
OR
• On the Map Navigator, right-click on the Target for which you want to browse the data and select Browse Data.
Note: You can view the Target Data without establishing the connection.
The Target Data tab displays the following information at the bottom:
• Target data file path and file name or database and table name.
• Target data in table format with column headings as Record Name, Field1, Field2, Field3, and so on.
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 target data. The searched text is highlighted in the Target Browser window.
• Click View Options and you can select any 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 target file data. 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 will display under the <SQL> table name.