Hi team,
I am using Talend Team edition 4.2 using to to load Teradata database. I have Install Teradata Client on my machine. I have two jar file:
1. tdgssconfig.jar
2. terajdbc4.jar
and placed in C:\jdbc Folder.
url string is com.teradata://<Ip_Config>/<DB_Name>
I have Class path environement variable as c:\jdbc
there is no space in the Talend Studio Directory.
I am using tTeradataMultiload Component to load database.
While executing tthe Job I have encounter the following error. I tried alot to solve but could not. Help me to solve this. Let me know if more info is requested.
connecting to socket on port 3482
connected
GSSException: Failure unspecified at GSS-API level (Mechanism level: UserFile parameter null)
at com.teradata.tdgss.jtdgss.TdgssParseXml.<init>(Unknown Source) at com.teradata.tdgss.jtdgss.TdgssConfigApi.<init>(Unknown Source) <
Thanks Pedro for youre reply and your suggeation.
As we are using DB type as our context and based on the DB, job will be executed and hence I am emphasize on to use JDBC Connection.
I check the version of the JDBC and its matching with the Teradata DB. I will also check your option.
Apart from this, I would like to know one more thing on Datatype. My target and source tables have Numeric datatype in Netezza Database. I need to implement one complex expression that has mathematical operation and case statement too.
but during implementation, I am facing several problem like big decimal issue and division required option like half down,half up etc.
Could you please help me to opt the better approach to implement this?
Cheers
Siegfried
Hi
Because this expression is complicated, I sugget that you should create a custom routine, which would make all stuff and your thought clear.
Regards,
Pedro
