importing meta data

koolsun85 · Post by **koolsun85** » Tue Aug 10, 2010 7:26 pm

hello,

I want ti import metadata from *.dat file sent from mainframes.
guide me
thanks in advance

ray.wurlod · Post by **ray.wurlod** » Tue Aug 10, 2010 9:25 pm

Do you have the associated COBOL file definition (FD) file?

If so import from that. If not, import the table definition for the Sequential File.

koolsun85 · Post by **koolsun85** » Wed Aug 11, 2010 10:16 am

when i open the *.dat in text pad i can see the data.
If i try to import the table def by sequential file def.. then it is not showing uo the files.
is there any other way to get the meta data...?

kumar_s · Post by **kumar_s** » Wed Aug 11, 2010 10:50 am

Use sequential file option to import the metadata, later use it in your DB stage. If thats what you are looking for.
Is the sequential file fill with actual data or Metadata?

vivekgadwal · Post by **vivekgadwal** » Wed Aug 11, 2010 11:17 am

koolsun85 wrote:when i open the *.dat in text pad i can see the data.
If i try to import the table def by sequential file def.. then it is not showing uo the files.
is there any other way to get the meta data...?

koolsun85,

If you are able to view the data from Mainframe, then it means that it is in ASCII form. However, it doesn't change the fact that it is a Cobol File and its definition (metadata) is obtained from a CFD (Cobol File Definition). Request one, if you don't have it already. If you have one, try importing it using DataStage, the process for which should be quite straightforward!

Hope this helps...