I cannot get the teradata fast export to run in Talend but the export script runs fine in the unix environment under the command line with modification. I am getting an error that says
Starting job javatest at 22:08 04/12/2010.
connecting to socket on port 3948
The system cannot find the file specified.
Job javatest ended at 22:08 04/12/2010.
I looked at the script file and I noticed that the server name is not in the login statment which in unix fast export is a problem.....With some modification I can get this to run if I restructure the syntax of the logon.
.BEGIN EXPORT SESSIONS 8;
cast( SVCDPTY_ECN_FNL as CHAR(100)),
cast( CALL_START_DT_PST as CHAR(10)),
cast( RECONTACT_IND as CHAR(3)),
cast( D_XFER_BTWN_BNKRS as CHAR(3)),
cast( TOTALDAY0_SVCTM_S as CHAR(10)),
cast( CLLBCK_DAYS_0 as CHAR(3)),
cast( CLLBCK_DAYS_1 as CHAR(3)),
cast( CLLBCK_DAYS_2 as CHAR(3)),
cast( CLLBCK_DAYS_3 as CHAR(3)),
cast( CLLBCK_DAYS_4 as CHAR(3)),
cast( CLLBCK_DAYS_5 as CHAR(3)),
cast( CLLBCK_DAYS_6 as CHAR(3)),
cast( CLLBCK_DAYS_7 as CHAR(3)),
cast( CALLBACK_TOTSVCTM_WK01 as CHAR(10)),
cast( D_FRPT_AUN as CHAR(45)),
cast( D_FRPT_LOB as CHAR(7)),
cast( N_SOJRN as CHAR(10)),
cast( SYSDATE_WK_OF_YR as CHAR(10)),
cast( SYSDATE_DAY_OF_WK as CHAR(10)),
cast( FOCAL_DAY as CHAR(24)),
cast( FOCAL_WEEK as CHAR(30)),
cast( YR as CHAR(100)),
cast( WEEK_OF_YEAR as CHAR(10)),
cast( TABLE_PK as CHAR(100)),
cast( FSOJRN_DRTN_SCNDS as CHAR(10)),
cast( DAY0INTRARECON_DRTN_SCNDS as CHAR(10))
.EXPORT OUTFILE C:\Documents and Settings\youngs\Desktop\TOS-Win32-r50363-V4.1.1\workspace\test.csv.data FORMAT TEXT mode record;
In looking through the error log the teradata database is not listed in the host file because the dns takes care of the look up. The TOS component is probabably looking for the cop entry in the host file which is not required. I can run the fast export outside of TOS from the windows utility. Is there a work around?
= FastExport Utility Release FEXP.13.00.00.009 =
= Platform WIN32 =
= Copyright 1990-2009 Teradata Corporation. ALL RIGHTS RESERVED. =
**** 08:45:47 UTY2411 Processing start date: SUN DEC 05, 2010
= Logon/Connection =
0001 .LOGTABLE xxxxxx.REPORTING_RECONTACT_xxxxxxx_lt;
0002 .LOGON youngsh,;
**** 08:45:49 UTY1006 CLI error: 224, MTDP: EM_NOHOST(224): name not in HOSTS file or names
**** 08:45:49 UTY2410 Total processor time used = '0.125 Seconds'
. Start : 08:45:47 - SUN DEC 05, 2010
. End : 08:45:49 - SUN DEC 05, 2010
. Highest return code encountered = '12'.
It now works. Teradata is looking for database name/username,password and you have to place it within the username field to make it work.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables