To integrate a new data source with existing enterprise
data, you need to understand how the data in the new source is related to
data in the existing environment. You can build a process that copies data
from the new source into the existing source. By defining mappings and relationships,
you can manipulate a large set of disparate metadata.
Learning objectives
When
you complete the exercises, you will know how to do the following tasks:
- Create a new data design project
- Access data models
- Create a new mapping model
- Find relationships between source and target elements
- Transform a source element to match a target element
- Generate an SQL script
30 minutes