DSXchange

Hi all,
My source and target is Teradata.I'm trying to execute the job it is aborting.My fatal error is

onnector_22: [IIS-CONN-TERA-005004] RDBMS code 3803: Table 'X' already exists.
SQL statement: CREATE TABLE SEBI_EDW.X (X_Id INTEGER NOT NULL, Lifecycle_Cd VARCHAR(50)
NOT NULL, X_Type_Cd VARCHAR(50) NOT NULL, MEMBERCODE VARCHAR(100), LONGNAME VARCHAR(100),
FIRMTYPE VARCHAR(100), TRADENAME VARCHAR(100), ADDRESS VARCHAR(100), PINCODE VARCHAR(100),
STATE VARCHAR(100), TELEPHONE VARCHAR(100), FAX VARCHAR(100), NATUREOFOFFICE VARCHAR(100),
DIRECTORNAMES VARCHAR(100), SEBIREGISTRATIONNO VARCHAR(100), MEMBERSTATUS VARCHAR(100),
SEGMENTCODE VARCHAR(100), BATCH_NO VARCHAR(10), LOAD_TIME CHAR(23)) PRIMARY INDEX (X_Id)
(CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,625)

please help

Regards
Suresh

Table X already exists in the SEBI_EDW schema.

There's nothing more to say.

No database will permit CREATE TABLE if the table named already exists.

Hi Ray,
I tried,these are the fatal errors i'm getting.
Teradata_Connector_34: Properties /Usage/WriteMode, /Usage/Session/ArraySize: Incompatible property values

Teradata_Connector_34: Error occurred during initializeFromArgs().

Thanks
suresh

Check the target database stage. Go to Input -> Options. Check in the create table action -> You should have Do not create target table.