#DateForumTypeThreadPost
2424 Aug 2016 @ 07:29 PDTAsterReplyload_from_hcatalog --- error while selecting Varchar,Date,Timestamp columnHi All, Can you please help us om load_from_hcatalog issue we are facing? Thanks in advance. Arpan.
2309 Aug 2016 @ 02:53 PDTAsterTopicload_from_hcatalog --- error while selecting Varchar,Date,Timestamp column Hi All, We are trying to read data from Hive table and load into teradata table after lots of transformation. So, we are trying to use "load_from_hcatalog". But while selecting dat...
2228 Jul 2016 @ 06:07 PDTToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, Are there any other tuning technique we meed to apply apart from those mentioned above.   Thanks & Regards, Arpan.
2114 Jul 2016 @ 07:55 PDTToolsReplyNeed Help regarding TPT ODBC Operator Hi Steve,   Using TPT ODBC Operator and DATA CONNECTOR Operator we are trying to fetch data from Oracle table. But the performance is not that much exciting it seems. In the existin...
2013 Jul 2016 @ 06:20 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Hi Steve, The ErrorField is "AR_CTGRY_CDE_ACR". Below is the schema defination from tpt control file. SYS_ACR INTEGER, --- Column I changed from NUMBER(4) to INTEGER PRIN_ACR NUMBER(...
1912 Jul 2016 @ 12:34 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Hi Steve, When I put INTEGER in schema defination, the script is not failing, but all the records are going to ET1 table. Below is the console log. Teradata Parallel Transporter Version 15.10....
1808 Jul 2016 @ 08:09 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Thanks a lot Steve. Just wanted to understand, what will be our focus while defining SCHEMA in tpt control file? Is it Source Table or Target Table? If Source and Target table is having different ...
1707 Jul 2016 @ 01:42 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Hi Steve, Thanks for your response. Below is my TPT contril file: DEFINE JOB LOAD_ACR_ACCTS_RECEIVABLE_TO_TABLE DESCRIPTION 'export LOAD_ACR_ACCTS_RECEIVABLE_TO_TABLE' ( ...
1606 Jul 2016 @ 07:11 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Thanks Steve and Dave. I'm also facing the same issue while reading data from Oracle table and loading into Teradata table. TTU version I'm using is 15.10. For reading from Oracle I'm u...
1524 Jun 2016 @ 04:26 PDTToolsReplyNeed Help regarding TPT ODBC OperatorThanks a lot Steve. Below is my locale settings in .bash_profile. export NLS_LANG=american_america.UTF8 #export LANG=C #export LC_ALL=C export LANG=en_US.UTF-8 export LC_ALL=en_US.UTF-8 ex...
1423 Jun 2016 @ 06:03 PDTToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, I'm able to extract data using TPT ODBC Operator and Data Connector Consumar. I'm using TTU 15.10. But while running the job, getting 6060  and 6062 like Carlos. Below is th...
1323 Jun 2016 @ 03:12 PDTToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, I've installed TTU15.10 in Linux. In which directory the Data Direct ODBC drivers will reside? Do we need any additional license or cost to het these drivers?   Thanks & R...
1228 May 2016 @ 12:00 PDTToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, Thanks for your response. I tried with -C option with LoadInst as 6 to write the data in 6 different files. There also I'm getting throughput around 800 rows/sec. But I haven't t...
1124 May 2016 @ 06:32 PDTToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, With -h as 100 M, I'm able to write the data into a flat file. But, when we are using Informatica we are getting throughput around 3000, but when I'm using TPT (ODBC Operator wit...
1020 May 2016 @ 03:36 PDTToolsReplyNeed Help regarding TPT ODBC OperatorThanks a lot Steve. I changed my tpt control file like below: APPLY TO OPERATOR (o_FileWritter[@LoadInst]) SELECT * FROM OPERATOR (o_ODBCOper[@ReadInst] ATTRIBUTES (SelectStmt=@Sele...
919 May 2016 @ 07:37 PDTToolsReplyNeed Help regarding TPT ODBC OperatorThanks a lot for the help. After installing Data Direct ODBC drivers for 32 bit, the connection is working.  Now, is there any way to read source data simultaniously with different SQLs (basi...
812 May 2016 @ 01:05 PDTToolsReplyNeed Help regarding TPT ODBC OperatorBelow are the output of the commands. 1) Below is the output for LD_LIBRARY_PATH. echo $LD_LIBRARY_PATH /usr/lib:/usr/local/lib:/opt/oracle/client-11.2.0/lib:/opt/Informatica/PowerCenter9.6.0/...
711 May 2016 @ 03:09 PDTToolsReplyNeed Help regarding TPT ODBC OperatorHi Vishnu, In LD_LIBRARY_PATH, that is added. Still no luck. Thanks & Regards, Arpan.
610 May 2016 @ 08:42 PDTToolsTopicNeed Help regarding TPT ODBC Operator Hi All, I create one ODBC Connection entry in ODBCINI file defined in .profile. OS is RHEL (Red Hat Enterprise Linux Server release 5.9 (Tikanga)). TPT Version is 14.10.00.08. INF...
528 Apr 2016 @ 12:06 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorThanks Steve. But waht is the cause of this warning and why I'm not able to see the TPT job log using tlogview command? Thanks & Regards, Arpan.
427 Apr 2016 @ 03:58 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorHi Steve, Teradata DB Version: 15.10.00.03 TPT Version: 14.10.00.08 The file is getting generated, but exit code is 4. So, when I'll call the job from Linux then, as return code is...
326 Apr 2016 @ 04:45 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorThanks a lot Steve. I'm not sure whether I should start a separate discussion/ thread for below question: Is there any restriction on the no of columns exported while using Export and Data Con...
222 Apr 2016 @ 03:18 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorHi Steve, Thank you very much for your input. It worked. So, ASCII or Uniode value of the TextDelimiter can't be given, rather specific character has to be given for TextDelimiter. Is that co...
121 Apr 2016 @ 01:20 PDTToolsTopicASCII value of the delimiter in TPT Export OperatorHi All, Is there any way to pass ASCII value of character in TextDelimiter for TPT Export Operator? I want to export  a "TAB" delimited file. But when I'm giving tab a sepa...