|
|
Archives of the TeradataForum
Message Posted: Fri, 21 Jun 2002 @ 12:08:15 GMT
Subj: | | Data load from Informatica powercenter to Teradata |
|
From: | | Ganesh Sundaralingam |
Hi all,
I have the following error when load a table from Powercenter to Teradata database.
Following from the Powercenter Log File:
----------------------------------------------------------------------
INSERT INTO CAR
(POCKEY,SSSNAME,EMAILSIGN,EMAILDOMAIN1,FRFRGN,BUBUSNA,FMFARM,NEWPHONE,PHONE0
102,PHONELENGTH,PHONEMOB,NTGBNAM,GCGBNAM,NPGBNAM,FNGBNAM,MNGBNAM,LNGBNAM,NGG
BNAM,NSGBNAM,ANGBNAM,MFGBNAM,NFGBNAM,SFGBNAM,MLGBNAM,HKGBNAM,PKGBNAM,NWGBNAM
,W1GBNAM,W2GBNAM,W3GBNAM,W4GBNAM,W5GBNAM,N1GBNAM,S1GBNAM,N2GBNAM,S2GBNAM,UPG
BNAM,UDGBNAM,IPGBNAM,EDGBNAM,UOGBNAM,SNGBADD,SDGBADD,SVGBADD,SFGBADD,BPGBADD
,BNGBADD,BDGBADD,BSGBADD,BFGBADD,BVGBADD,DQGBADD,DPGBADD,DNGBADD,DDGBADD,DSG
BADD,TQGBADD,TPGBADD,TNGBADD,TDGBADD,TSGBADD,PDGBADD,PVGBADD,ATGBADD,NTGBADD
,RTGBADD,UPGBADD,UDGBADD,IPGBADD,EDGBADD,UOGBADD,BLGBARE,DLGBARE,PTGBARE,CYG
BARE,OCGBARE,ICGBARE,CCGBARE,PNGBARE,UPGBARE,UDGBARE,IPGBARE,EDGBARE,UOGBARE
,NAGBPRE,ADGBPRE,ARGBPRE,OTGBPRE,P1GBPRE,P2GBPRE,P3GBPRE,P4GBPRE,P5GBPRE,P6G
BPRE,IPGBPRE,OPGBPRE,UOGBPRE,ORDER_FLD,FILENAME,FILEDATE,ADD1,ADD2,ADD3,ADD4
,ADD5,ADD6,POSTCODE,TITLENAME,INITIALS,FORENAME,SURNAME,URN1,URN2,URN3,URN4,
PHONE,DOB,SALUTATION,BIRENDATE,CIRENDATE,MIRENDATE,RENDATE,NEWADD1,NEWADD2,N
EWADD3,NEWADD4,NEWADD5,NEWADD6,NEWPCODE,RTNPCODE,PAFSTATUS,EMAILADDR,GENDER,
URNSUP,MORTSUPP,HNAME,DWRECKEY,MTCTYPE,TELEMPHONE) VALUES
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_2_1> WRT_8124 Target Table CAR :SQL UPDATE statement:
UPDATE CAR SET SSSNAME = ?, EMAILSIGN = ?, EMAILDOMAIN1 = ?, FRFRGN = ?,
BUBUSNA = ?, FMFARM = ?, NEWPHONE = ?, PHONE0102 = ?, PHONELENGTH = ?,
PHONEMOB = ?, NTGBNAM = ?, GCGBNAM = ?, NPGBNAM = ?, FNGBNAM = ?, MNGBNAM
= ?, LNGBNAM = ?, NGGBNAM = ?, NSGBNAM = ?, ANGBNAM = ?, MFGBNAM = ?,
NFGBNAM = ?, SFGBNAM = ?, MLGBNAM = ?, HKGBNAM = ?, PKGBNAM = ?, NWGBNAM
= ?, W1GBNAM = ?, W2GBNAM = ?, W3GBNAM = ?, W4GBNAM = ?, W5GBNAM = ?,
N1GBNAM = ?, S1GBNAM = ?, N2GBNAM = ?, S2GBNAM = ?, UPGBNAM = ?, UDGBNAM
= ?, IPGBNAM = ?, EDGBNAM = ?, UOGBNAM = ?, SNGBADD = ?, SDGBADD = ?,
SVGBADD = ?, SFGBADD = ?, BPGBADD = ?, BNGBADD = ?, BDGBADD = ?, BSGBADD
= ?, BFGBADD = ?, BVGBADD = ?, DQGBADD = ?, DPGBADD = ?, DNGBADD = ?,
DDGBADD = ?, DSGBADD = ?, TQGBADD = ?, TPGBADD = ?, TNGBADD = ?, TDGBADD
= ?, TSGBADD = ?, PDGBADD = ?, PVGBADD = ?, ATGBADD = ?, NTGBADD = ?,
RTGBADD = ?, UPGBADD = ?, UDGBADD = ?, IPGBADD = ?, EDGBADD = ?, UOGBADD
= ?, BLGBARE = ?, DLGBARE = ?, PTGBARE = ?, CYGBARE = ?, OCGBARE = ?,
ICGBARE = ?, CCGBARE = ?, PNGBARE = ?, UPGBARE = ?, UDGBARE = ?, IPGBARE
= ?, EDGBARE = ?, UOGBARE = ?, NAGBPRE = ?, ADGBPRE = ?, ARGBPRE = ?,
OTGBPRE = ?, P1GBPRE = ?, P2GBPRE = ?, P3GBPRE = ?, P4GBPRE = ?, P5GBPRE
= ?, P6GBPRE = ?, IPGBPRE = ?, OPGBPRE = ?, UOGBPRE = ?, ORDER_FLD = ?,
FILENAME = ?, FILEDATE = ?, ADD1 = ?, ADD2 = ?, ADD3 = ?, ADD4 = ?, ADD5
= ?, ADD6 = ?, POSTCODE = ?, TITLENAME = ?, INITIALS = ?, FORENAME = ?,
SURNAME = ?, URN1 = ?, URN2 = ?, URN3 = ?, URN4 = ?, PHONE = ?, DOB = ?,
SALUTATION = ?, BIRENDATE = ?, CIRENDATE = ?, MIRENDATE = ?, RENDATE = ?,
NEWADD1 = ?, NEWADD2 = ?, NEWADD3 = ?, NEWADD4 = ?, NEWADD5 = ?, NEWADD6
= ?, NEWPCODE = ?, RTNPCODE = ?, PAFSTATUS = ?, EMAILADDR = ?, GENDER =
?,
URNSUP = ?, MORTSUPP = ?, HNAME = ?, DWRECKEY = ?, MTCTYPE = ?,
TELEMPHONE
= ? WHERE POCKEY = ?
WRITER_1_2_1> WRT_8124 Target Table CAR :SQL DELETE statement:
DELETE FROM CAR WHERE POCKEY = ?
WRITER_1_2_1> Fri Jun 21 12:13:21 2002
WRITER_1_2_1> WRT_8123
Failed to prepare target table load.
Database error: -1
WRITER_1_2_1> WRT_8164 Error loading into target [CAR] :
Any help would much appreciated!!!!
Ganesh
| |