|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/27/2007 3:02:00 PM
Posts: 1,
Visits: 1
|
|
|
Is any one in this forum using Metadata Services? We are looking to work with it but wanted to get some info on those that are using it and their experience? what they use it for and how they use it. Any info will help.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/1/2008 11:36:43 AM
Posts: 2,
Visits: 4
|
|
Sorry for the delayed response. We are just starting to use MDS and trying to figure out how to load it from ERwin and other sources, and how to access the metadata in a more simple and intuitive way than using the Metadata Browser.
- Robert Gordon
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/25/2008 5:33:02 PM
Posts: 3,
Visits: 7
|
|
ERwin lets you export directly to MDS. ERwin 7 or later has bridges from Meta Integration Technology Inc. (MITI) embedded and provides an export wizard that lets you pick Teradata MDS as the target export.
When you move ERwin model information into MDS you have 2 scenarios. The bridge first looks to see if the physical metadata from ERwin (i.e. tables, columns, views) already exists in MDS:
1) If the answer is yes, the bridge will only export out the logical model ( entities, attributes, etc.) and then associates these to the corresponding warehouse data already loaded in MDS.
2) If the answer is no, the bridge will export both the physical and logical data from the models.
The bridge also allows you to export ERwin modeling information from RDBMS other than Teradata into MDS. So if you have an ERwin model for DB2, SQLServer, etc., you can still export this out into MDS and there will be a field in the Database class that identifies the database type it represents.
|
|
|
|