Fastload Question

Tools
Enthusiast

Fastload Question

I need to export flat files out of Oracle and Fastload it into Teradata.,

Let's take an example

A table has say 5 fields and these are integers & dates

I am sending them in this format

6305,1451,2400,41,3,200403,0,887.03,-8.64,0,0
60,100,6005,10,3,200806,0,24830.57,189.78,0,0
3532,100,4120,3,3,200711,0,2623.44,10.83,0,0
48,100,2,24,3,200711,0,5590.08,85.79,0,0
48,100,2,16,3,200711,0,4468.66,-.97,0,0

My Fastload script uses the following

SET RECORD VARTEXT ",";

CREATE TABLE STAGING (
C_ID VARCHAR(10),
V_ID VARCHAR(10),
S_ID VARCHAR(10),
CO_ID VARCHAR(10),
CH_ID VARCHAR(10),
FP_ID VARCHAR(6),
A_Qty VARCHAR(10),
P_Qty VARCHAR(10),
T_Qty VARCHAR(10),
R_Amt VARCHAR(10),
Rp_Amt VARCHAR(10)
)
;
DEFINE

C_Id (VARCHAR(10)),
V_Id (VARCHAR(10)),
S_Id (VARCHAR(10)),
CO_Id (VARCHAR(10)),
CH_Id (VARCHAR(10)),
FP_Id (VARCHAR(6)),
A_Qty (VARCHAR(10)),
P_Qty (VARCHAR(10)),
T_Qty (VARCHAR(10)),
R_Amt (VARCHAR(10)),
Rp_Amt (VARCHAR(10))

but the data in final table needs to be Integer & Date formats

How do I make sure that no data is lost or truncated in the staging area?
1 REPLY
hh
Enthusiast

Re: Fastload Question

After you load the data in staging, you can always issue some sqls to look at the data, right? Or perform some aggregations on Oracle then compare to Teradata.