Mapping Specification Sources
When you create a mapping specification, you must add one or more sources to it. When you add multiple source to a mapping specification, you must specify a join between the sources.
You can use tables, flat files, logical data objects, social media objects, and mapping specifications as sources.
If an external source changes, you can synchronize the changes with corresponding source objects in a mapping specification. After you synchronize the changes, the Analyst tool updates the mapping specification to match the changes in the data object. You must open the mapping specification again to view the updated source.
You can search for source columns in the mapping specification. You can add source columns to the target, rules, filters, or joins. You can also automatically map source columns to target columns based on naming conventions and column positions. You can drag multiple source columns to the target to insert between existing target columns.
You can remove a source from the mapping specification. When you remove a source that is referenced by other objects, the Analyst tool displays a lists of referenced objects. If you remove the source that has referenced objects, the mapping specification is not valid.
Adding and Editing a Source
Use the Edit Mapping Specification window to add or edit a source. You can add multiple sources to a mapping specification. Add sources to use additional data objects in the mapping specification. You can remove a source from a mapping specification.
1. From the Actions menu, click Edit > Sources.
The Edit Mapping Specification wizard appears.
2. On the Sources tab, click the Add icon.
The Add Source Object wizard appears.
3. On the Source Object panel, click each checkbox to select a source or sources from a project.
4. Optionally search for a source by name or tag in the search box.
5. Optionally, select a source and click Data Preview to preview the source.
6. Optionally, select a source and click Properties to view the source properties.
7. Click OK.
8. Optionally, select a source and click the Delete icon to remove it from the mapping specification, and click OK.
9. Click Save.