Fast load for Teradata

Below is a sample script that I've used to import data into a Teradata DWH using the Fast Load tool. Teradata is a real hassle in not having any bulk import functionality like Oracle. Took me hours to understand what is going on and getting the script to work.

In any case, sharing it here for others to refer to.
//test.csv
node,cluster_id,node_type
XXXX12710,1,msisdn
XXXX643124,2,msisdn
//

SESSIONS 5;
LOGON /,;
CREATE TABLE , NO FALLBACK
   (
    NODE VARCHAR(50) ,
    CLUSTER_ID VARCHAR(10),
    NODE_TYPE VARCHAR(10)
   )
   PRIMARY INDEX(NODE);

begin loading 
+ tablename>
errorfiles 
+ tablename>_err1, + tablename>_err2;
set record vartext ",";
record 2;
DEFINE  NODE (VARCHAR(50)),
        CLUSTER_ID (VARCHAR(10)),
NODE_TYPE (VARCHAR(10))
FILE=D:\test.csv;

insert into 
+ tablename> values
(
:NODE,
:CLUSTER_ID,
:NODE_TYPE
);
END LOADING;
LOGOFF;
quit;

Comments

Popular posts from this blog

HIVE: Both Left and Right Aliases Encountered in Join

Assign select result to variable in Netezza stored procedure

Splitting value in Netezza using array_split