Mapping Details
When you click on the Mappings tab, the panel on the left displays the list of destination tables. The panel on the right also displays the destination tables and provides additional details such as the percentage of columns in that table that have already been mapped.
Note: The percentage mapping shows a percentage based on the number of
mapped fields versus the number of total fields in the destination. In some
cases, not all fields will apply to the selected source system, so you may not
have 100% completion displayed even though all applicable fields are included.
Tables marked 'Ignore in extract' will display 100% as this would indicate that
no more mapping was required for the table.
Click a destination table on the left to see details of that table and its mapping on the right as follows:
- Source Tables for Mapping: This tab displays the tables from which columns are mapped to the destination table columns. If the destination table is not mapped, this panel does not display day. You must add the source tables to review data.
- Destination Columns: This tab displays the columns in the destination table selected on the left panel.
- From Clause : This tab displays the table from which the data is extracted. If data is extracted from two or more source tables, this tab displays the join that is defined.
- Where Clause : This tab enables you scope the data being extracted. If no Where Clause is specified, all data from the source table are extracted.
- Group By/Having Clause: The
tab enables you to collect data across multiple records and groups the results
by one or more columns. For example you could group results by employee ID .
The Having Clause can be used in a SELECT statement to filter the records that a Group By clause returns.
- Date Scoping Filters: This tab enables you to filter data of a destination table based on the creation or updated date.