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:

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:

Posted: Thu Jun 03, 2010 11:56 pm
by ray.wurlod
Guess so.
:lol:

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.