Page 1 of 1
Read Dat file in datastage
Posted: Thu Jun 03, 2010 5:46 pm
by rameshkm
I have a Dat file as source, any one can say how to read this file in datastage , please help in this
Posted: Thu Jun 03, 2010 6:10 pm
by chulett
Dat file? Digital Audio Tape? Something with a .dat extension?
Have you tried to import the metadata from it or have you been given the same? Can you post some sample records?
Posted: Thu Jun 03, 2010 6:50 pm
by truenorth
If it's just a flat file, use the Sequential File stage.
Posted: Thu Jun 03, 2010 7:52 pm
by chulett
Gonna need some metadata for that.
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Thu Jun 03, 2010 10:56 pm
by ray.wurlod
Nah.
Don't need no stinkin' metadata.
The question was "read", not "parse".
I guess we don't want to guess any more. Let's await the original poster's amplification of what, after all, could be an interview question.
Posted: Thu Jun 03, 2010 11:29 pm
by chulett
Gotcha - read first, ask parsing questions later.
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Thu Jun 03, 2010 11:56 pm
by ray.wurlod
Guess so.
![Laughing :lol:](./images/smilies/icon_lol.gif)
Posted: Fri Jun 04, 2010 12:46 am
by ray.wurlod
Seriously, though, rameshkm needs to elaborate what is meant by "Dat file", as requested.