Hi All,
Is there a way of automating the process of Metadata Generation?
My requirement would be like this :
1.If the metadata of a file is present in an excel/text/word file, Can that be read and converted into a internal Metadata format in Datastage automatically.
If there is, please guide me through this and any other way of acheiving this scenario.
Generating Metadata Automatically
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
There are a couple ways. I once worked with someone who built a MS Word macro that took a Word table and turned it into a DataStage table definition in the format of an export file. This could be used to import Word metadata tables into DataStage table definitions.
The other way is to use FastTrack - the Information Server source to target mapping tool in version 8.0.1. It can import mappings from a spreadsheet or access metadata from the dozens of metadata bridges in version 8. It can then automate some of the source to target mapping work and generate DataStage jobs.
The other way is to use FastTrack - the Information Server source to target mapping tool in version 8.0.1. It can import mappings from a spreadsheet or access metadata from the dozens of metadata bridges in version 8. It can then automate some of the source to target mapping work and generate DataStage jobs.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn