We have integrated Cognos with Metadata Workbench and are able to check lineage from Cognos reprots to DS jobs successfully.We are trying to enhacne it a bit more and trace it back to the actual source data files.
We din't find any option to import data files into workbench in the Import/export manger utility.What is the method or process to import data files into workbench?
Would also like to know..Will running automated services map the physical source files(*.csv or *.txt ) to the DS sequential file stage automatically?
Version:Workbench 8.1.0 and Import/Export Manager 8.1fp1 -101309
This topic has been locked.
1 reply Latest Post - 2009-11-12T20:20:53Z by MarcHaber
Pinned topic How to import data fiel into Metadata Workbench?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-11-12T20:20:53Z at 2009-11-12T20:20:53Z by MarcHaber
MarcHaber 060001Y53G11 PostsACCEPTED ANSWER
Re: How to import data fiel into Metadata Workbench?2009-11-12T20:20:53Z in response to SystemAdminData Files are imported via the DataStage Designer using the legacy Sequential File import. The File is imported as a Table Defition, which would require to be published as Shared Metadata. Selecting the created Table Definition, right-click the object and select Shared Table Creation Wizard.
The attached document has more information regardng the import and publishing of a Data File.