Page 1 of 1
.dat file
Posted: Wed Jul 16, 2008 1:07 pm
by kumarpds
Hi all,
I want to read data from a .dat file on my unix box and load into an oracle table. can you please tell me which stage can be used to read the .dat file. Seq. file / CFF /.....
I gave a try with this design a
Seq. File -------> Trfm -------> ODBC stage. But then I realised Seq. file may not work for .dat file.
Help me
Thanks in advance
Kumar
Posted: Wed Jul 16, 2008 1:14 pm
by chulett
Extensions can be fairly meaningless, where did the file come from? More than likely it's a sequential file and can be read with that stage, can you view it properly with vi?
Posted: Wed Jul 16, 2008 1:29 pm
by kumarpds
oops
Posted: Wed Jul 16, 2008 1:30 pm
by kumarpds
chulett wrote:Extensions can be fairly meaningless, where did the file come from? More than likely it's a sequential file and can be read with that stage, can you view it properly with vi? ...
Mr.Chulett,
It was ftped by different business and the location is given to me. S, I can view the data using vi.
i used the seq. file stage, in the properties gave file location //data/path/filename.dat, imported the column definitions. Job is running but with warnings and no data is loading into target table
Warning :
Sequential_File_0,0: Delimiter for field "EMPID" not found; input: {2 0 4 0 5 5 20 20 20 20 20 20 20 20 20 C r a i g 20 20 20 20 20 20 M a t t20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 F T 20 20 20 A 20 W h o l e 20 I n f o r m a t i o n 20 T e c h n o l o g y 20 20 20 20 20 20 20 20 20 20 20 C o r p o r a t e 20 S y s t e m s 20 I T 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 I n f o r m a t i o n 20 T e c h n o l o g y 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 1 20 L y n a m D r i v e 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 N e w a r k 20 20 20 20 20 20 20 20 20 20 20 D E 20 20 20 20 20 20 20 20 1 9 0 2 6 20 20 20 20 20 20 20 20 20 20 c r a i g @ y a h o o . c o m 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 1 2 3 / 4 5 6 - 7 8 9 0 20 20 20 20 20 20 20 20 20 20 20 0d}, at offset: 0
Thank You
Kumar
Posted: Wed Jul 16, 2008 1:36 pm
by chulett
Did they not give you a file layout? Can you post that and a sample record or two, wrapped in
Posted: Wed Jul 16, 2008 2:17 pm
by kumarpds
chulett wrote:Did they not give you a file layout? Can you post that and a sample record or two, wrapped in
Code: Select all
tags? ...[/quote]
No layout is given, I presume it to have the same layout as the destination table, which has around 15 columns.
[code]468742 Craig Matt FT A Global Information Technology
Corporate Systems IT Information Technology 1 Lynam Drive
Newark DE 19702 cragi_matt@yahoo.com 302/123-4567
Thank You
Kumar
Posted: Wed Jul 16, 2008 3:25 pm
by chulett
You need a layout so you know what's what without guessing. What field delimiter is the file using?
ps. You need to enable BBCode in your posts for the tags to work properly.
Posted: Fri Jul 18, 2008 7:38 am
by Roopanwita
You can try with CFF stage or using Sequential File stage , In
Sequential File -->Format-->Record Level(right Click)---->Mainframe(COBOL)
Hope this will help out!
