Hi,
Could some assist loading a fixed width file with 3 columns as below using Dwloader.
The Table Definition, Format file and Source Data is available as below.
---Table Definition --
CREATE TABLE SRC_TEST( ID varchar(1) , Col2 decimal(7,3),Col3 Date)WITH (DISTRIBUTION = HASH(ID));
--Format File --
ID=1
Col2=10
Col3=8
--Source Data
1000009000020140413
2000008000020140413
Col 2 is 10 characters wide in the text file and should import into decimal(7,3).
So 0000090000 in the text file should land in the table as 90.000
Col3 3 is 8 characters wide in the text file and should import into datetime. So 20140412 should become 4-12-2014
I tried multiple ways by tweckking the format file and Table definition without success.
Please suggest me Format file layout and create Table script that should be in place get the result expected.
- Edited by Yuva Chandra Wednesday, July 01, 2015 6:20 PM
Other recent topics
