Page 1 of 1
importing meta data
Posted: Tue Aug 10, 2010 7:26 pm
by koolsun85
hello,
I want ti import metadata from *.dat file sent from mainframes.
guide me
thanks in advance
Posted: Tue Aug 10, 2010 9:25 pm
by ray.wurlod
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.
Posted: Wed Aug 11, 2010 10:16 am
by koolsun85
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...?
Posted: Wed Aug 11, 2010 10:50 am
by kumar_s
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?
Posted: Wed Aug 11, 2010 11:17 am
by vivekgadwal
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...