.dat file
Moderators: chulett, rschirm, roy
.dat file
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
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
Mr.Chulett,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? ...
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
Did they not give you a file layout? Can you post that and a sample record or two, wrapped in
Code: Select all
tags?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:Did they not give you a file layout? Can you post that and a sample record or two, wrapped inCode: 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
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India