FASTLOAD UTILITY- LOADING DATA FROM CSV FILE HAVING 143 COLUMNS TO A TERADATA TABLE

Teradata Applications
N/A

FASTLOAD UTILITY- LOADING DATA FROM CSV FILE HAVING 143 COLUMNS TO A TERADATA TABLE

Hi All,

I have am newly using the Fastload utility for loading data from CSV file to a table in Teradata.

I am able to successfully load for 10 columns from CSV file to table .This is my Scenario1

When i am trying with an SECOND  scenario of Loading 143 columns from CSV file to a table in Teradata

I am unable to do it thru Fastload

Fastload is stopping in middle while displaying no error message

In the second scenario , the length of the column names are around 41 digits

Example

ABC_DEF_GHI_JKL_MNO_PQR_STU_123_456_789Q

ABC_DEF_GHI_JKL_MNO_PQR_STU_123_456_789R

ABC_DEF_GHI_JKL_MNO_PQR_STU

Fastload Script used for Scenario1 and able to load data successfully:-

.LOGMECH LDAP

.SESSIONS 4;

LOGON servername/username,pwd:

/* Drop Tables*/

drop table SCHEMA.TABLE1;

drop table SCHEMA.TABLE1_ERR1;

drop table SCHEMA.TABLE1_ERR2;

CREATE TABLE SCHEMA.TABLE1

(

Col1     VARCHAR(100),

Col2     INTEGER

);

/*To Skip the header and provide the delimiter details*/

 RECORD 2;

 SET RECORD VARTEXT ",";

DEFINE

in_Col1         (VARCHAR(30)),

in_Col2              (VARCHAR(30))

/*FILE COMMAND DEFINES THE DATA FILE PATH AND NAME*/

FILE=path/sampl.csv;

/*Begin Loading*/

 BEGIN LOADING  SCHEMA.TABLE1

 ERRORFILES   SCHEMA.TABLE1_ERR1,SCHEMA.TABLE1_ERR2;

 INSERT INTO SCHEMA.TABLE1

(

Col1=:in_Col1,

Male_Cnt=:in_Male_Cnt

);

END LOADING;

LOGOFF;

Please provide me some inputs to resolve this issue for the Scenario2

Thanks

RCETL