Metadata Manager
This section describes changes to Metadata Manager in version 10.0.
ODBC Connectivity for Informix Resources
Effective in version 10.0, when you load an Informix resource, the PowerCenter Integration Service uses ODBC to connect to the Informix database. Therefore, you can create and load Informix resources whether the Informatica domain runs on Windows or UNIX. To connect to Informix, you must configure an ODBC connection to the Informix database.
Previously, the PowerCenter Integration Service used native connectivity to connect to the Informix database. You could create and load Informix resources only when the Informatica domain ran on 32-bit Windows.
For more information about configuring Informix resources, see the "Database Management Resources" chapter in the Informatica 10.0 Metadata Manager Administrator Guide.
ODBC Connectivity for Microsoft SQL Server Resources
Effective in version 10.0, when you load a Microsoft SQL Server resource, the PowerCenter Integration Service uses ODBC to connect to the database. The PowerCenter Integration Service retrieves the server name and the database name from the connect string and creates a data source using the installed ODBC driver.
Therefore, you no longer need to perform the following tasks when you configure a Microsoft SQL Server resource:
- •On Windows, you do not need to install the Microsoft SQL Server Native Client.
- •On UNIX, you do not need to create a data source for the Microsoft SQL Server database in the odbc.ini file.
Note: If you previously created a data source in the odbc.ini file, you can still use it by entering the data source name as the connect string.
- •You do not need to set the ODBC Connection Mode property for the Metadata Manager Service in the Administrator tool. This property is removed because the connection mode for Microsoft SQL Server is always ODBC.
Previously, the PowerCenter Integration Service used native connectivity on Windows and ODBC connectivity on UNIX.
For more information about configuring Microsoft SQL Server resources, see the "Database Management Resources" chapter in the Informatica 10.0 Metadata Manager Administrator Guide.
Impact Summary for PowerCenter Objects
Effective in version 10.0, the impact summary displays different information when you view metadata details for some PowerCenter objects.
The impact summary has the following behavior changes:
- •When you view metadata details for a session task instance, Metadata Manager lists the mappings that the session task instance runs as related catalog objects but not in the impact summary.
Previously, Metadata Manager listed the mappings as related catalog objects and in the upstream and downstream impact summary.
- •When you view metadata details for a mapplet instance that contains a source definition, Metadata Manager does not list the parent mapping in the impact summary.
Previously, Metadata Manager listed the parent mapping in the downstream impact summary.
- •When you view metadata details for a mapplet instance that does not contain a source, Metadata Manager does not display an impact summary.
Previously, Metadata Manager displayed an impact summary for mapplet instances that do not contain a source.
- •When you view metadata details for an Input or Output transformation instance in a mapplet, Metadata Manager does not display an impact summary.
Previously, Metadata Manager displayed an impact summary for Input and Output transformation instances in a mapplet.
- •When you view metadata details for a Source Qualifier instance in a mapplet that contains a source definition, Metadata Manager does not display the parent mapping in the impact summary.
Previously, Metadata Manager displayed the parent mapping in the impact summary.
For more information about the impact summary, see the "Viewing Metadata" chapter in the Informatica 10.0 Metadata Manager User Guide.
Maximum Concurrent Resource Loads
Effective in version 10.0, the maximum value for the Max Concurrent Resource Load property for the Metadata Manager Service is 10. Therefore, you can load up to 10 resources simultaneously.
Previously, the maximum value for the property was 5.
For more information about the Max Concurrent Resource Load property, see the "Metadata Manager Service" chapter in the Informatica 10.0 Application Service Guide.
Search
Effective in version 10.0, Metadata Manager displays the advanced search criteria and the search results in the Search Results panel at the bottom of the Browse tab. The Search Results panel allows you to view the metadata catalog, business glossaries, shortcuts, or data lineage diagram while you perform a search. You can resize, minimize, and restore the Search Results panel.
Previously, Metadata Manager displayed the advanced search criteria and the search results on a separate tab.
For more information about searches, see the "Searching Metadata" chapter in the Informatica 10.0 Metadata Manager User Guide.
Metadata Manager Log File Changes
Effective in version 10.0, the location for the Metadata Manager log files is updated to store all the log files in one directory.
The following Metadata Manager log files are stored in the directory <Informatica installation directory>\logs\<node name>\services\MetadataManagerService\<Metadata Manager service name>:
- •Load details archive log
- •mm_agent.log
- •mm.log
- •resourcemigration.log
- •mmrepocmd.log
Note: mmerepocmd.log is stored in the new log files directory when the Metadata Manager Service calls mmRepoCmd. If you run mmRepoCmd from the command line, the utility creates the log file in the directory where mmRepoCmd is located.
In the previous versions of Metadata Manager, these log files were located in different directories. After you upgrade Metadata Manager from a previous version to version 10.0, the existing log files do not get moved to the new location.
For more information about Metadata Manager log files, see the Informatica 10.0 Metadata Manager Administrator Guide.
Business Glossary Model
Effective in version 10.0, you cannot export or import the Business Glossary model. Additionally, you cannot customize the Business Glossary model by configuring attributes or relationships.
To export and import business glossary assets and templates or to customize business glossaries, use the Analyst tool.
Profiling
Effective in version 10.0, Metadata Manager does not extract profiling information from relational metadata sources.
Profiling is available in the Analyst tool and the Developer tool.