Information integration modeling provides a set of functions in
the data perspective that can help you manage metadata In an enterprise that
includes content and data structures from a variety of sources, understanding
the metadata is a crucial part of an integration solution. 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.
You can use the enterprise metadata tools that are provided with this product
to find and map relationships among a variety of data sources, build scripts
that represent those relationships, and then deploy scripts to federated,
non-federated, local, or remote servers. Use InfoSphere Information Server
to access diverse data and the processes that support the data. Then, use
enterprise data modeling to interpret and exploit the metadata. The metadata
functions in this product include:
- Discover relationships
- Provides methods to show you how one or more source schemas might be related
to a target schema. The relationships can be based on the metadata or any
available data samples.
- Map relationships
- Provides a visual representation of source and target data models and
the relationships that are either discovered or manually specified. The mapping
describes how you can combine and transform data that is represented by one
or more source models into some form that is appropriate to a target model.
The results are saved in a mapping model.
- Build expressions
- Provides you with a way to define criteria, such as functions, join conditions,
filter conditions, and sort conditions, that you can add to the mapping model.
You can then use the expressions in scripts that you deploy.
- Generate scripts
- Generates a script from the mapping model that you can deploy. You can
use the script to transform and filter data from mapping model compliant sources
to mapping model compliant targets.