Overview of information integration modeling

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.

Feedback