Can I import the structure of flat files to Information Steward for Metadata Management ?

[former_member1108223]

Hi,

In my data warehouse project, there are some dataflows which get data from flat file. Can I import the structure of these flat files to Information Steward for Metadata Management ? If yes, please tell me how to do ? I want to view the relationships between these objects and the others objects.

[Former Member]

Hi Mau Vu Huu,

  Yes, u can import the structure of flat files to IS. You need to create file connection in CMC by providing the file path. Then login to IS, go to DataInsight and follow the below steps-

1. Go to File format, click New, select file format.

2. Give file format name and description, upload the sample file, where schema is exactly matching to your source file (flat file) or you can upload the flat file directly.

3. Select the Delimiter whether your file is separated by tab or space or comma etc..

4. Select first row contains field names, then propose schema.

5. Save it and close it

6. Go to Workspace home, add files by selecting the file connection and file format 

7. Then add files to Project.

Thanks,

Hema