none
Dwloader - Loading a Fixed Width file RRS feed

  • Question

  • Hi,

    Could some assist loading a fixed width with 2 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) , PAT_AMT decimal(6,2))WITH (DISTRIBUTION = HASH(ID));

    --Format File --

    ID=1
    PAT_AMT=4

    --Source Data

    12222

    23333

    Upon dwloader execute the data is loading as below

    1  2222.00

    2 3333.00

    I would like to load this as 1  22.22 and 2 33.33

    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.


    Monday, June 29, 2015 8:48 PM

Answers