All forum activity

#DateUserForumTypeThreadPost
5821706 Jul 2016 @ 08:06 PDTmonchomarkToolsTopicTPT EXPORT OPERATOR job structure Hi guys, can you help me with a basic structure for a TPT EXPORT operator job? I have good examples on LOAD operator but I'm not sure what to change ar what's needed. T...
5821606 Jul 2016 @ 07:11 PDTArpan.RoyToolsReplyTPT 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...
5821506 Jul 2016 @ 07:05 PDTokhereDatabaseTopicA problem with 'where'Hi, i am fresh in sql and teradate. When i used ‘where’  to filter the data from AUG, 2004  WHERE a.num_month<>8 and a.num_year<>2004 The result seems all the da...
5821406 Jul 2016 @ 05:36 PDTHuguesRenaudDatabaseReplyTPTHello, Maybe ErrorLimit is set to zero. ErrorTable1 contains bad data, data conversion error or violation constraint, ErrorTable2 contains any rows that cause violation of unique primary index. H...
5821306 Jul 2016 @ 04:01 PDTdhiraj_dt121ToolsTopicTPT export to delimited files ErrorError : TPT_INFRA: TPT02638: Error: Conflicting data length for column(5) - STATE. Source column's data length (16) Target column's data length (8). EXPORT_OPERATOR: TPT12108: Output Sc...
5821205 Jul 2016 @ 11:48 PDTVinay151DatabaseTopicDecimal ValueHi,      I created a column with datatype Decimal(15,2) and when I store the value 0.00 in that column, its storing as .00. So, is there any way to store my value 0.00 as it is in ...
5821105 Jul 2016 @ 02:35 PDTsharatbalajiDatabaseTopicTPTI am trying to load a table in teradata using informatica with teradata parallel transported connection with an update operator. I want to see how the data in INFA_ET1 and INFA_ET2 looks like. So ...
5821005 Jul 2016 @ 01:36 PDTdnoethDatabaseReplyDatabase per object type -- Best practice or over engineered?@gerald.waters: IMHO Tom Nolan already answered the "DB names follow no pattern" part, there are naming conventions, of course. It is also common practice to seperate tables from user a...
5820905 Jul 2016 @ 12:58 PDTfgrimmerTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listing@kchinad, Can you verify thru Ambari that your JDBC port number is correct? Can you run Hive commands on your Hadoop system?
5820805 Jul 2016 @ 12:47 PDTdnoethDatabaseReplyFind position of a character in a stringYou can use oTranslate to remove multiple characters: oTRANSLATE(col, 'ae','')
5820705 Jul 2016 @ 12:47 PDTsrikanth471DatabaseReplyPartitoinThanks dnoeth....
5820605 Jul 2016 @ 12:46 PDTdnoethDatabaseReplyPartitoinNo, you can't add partitions when you use CASE_N. This should have been RANGE_N from the beginning like this: RANGE_N (SYR BETWEEN 201501 AND 201504 EACH 1, 201601 A...
5820505 Jul 2016 @ 11:47 PDTfgrimmerTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listing@kchinad, Is it possible that your username or password for Hive is bad? Have you tried hdfs and no password? Our systems have username guest and password guest-password. Not sure if that is standa...
5820405 Jul 2016 @ 11:42 PDTamilkar0417ToolsReplySQL Syntax CheckerI my experience, using EXPLAIN is not enough. I often need to create scripts that involve several queries in which the first few queries create new objects and the next queries make a reference to ...
5820305 Jul 2016 @ 11:36 PDTpavani39DatabaseReplyFind position of a character in a stringHi all, i wnat to replace multiple characters in a colums. example:-abcdefa want to replace 'a' and 'e'.o/p should be 'bcdf' Can any one please help me in this.
5820205 Jul 2016 @ 11:33 PDTsrikanth471DatabaseTopicPartitoinHello Every One,   I have the below table and i need to add the few more partitions without dropping the table. Is this possible ? Below are the partitions needed. SYR =  201401 , ...
5820105 Jul 2016 @ 11:13 PDTHustlerDatabaseReplyUnable to release locksHi Fred/All Please suggest me Regarding archive loggs: Is there anyway we could run both FASTLOAD AND Backups parallely on the same objects?          Trouble is DBC...
5820005 Jul 2016 @ 11:10 PDTHustlerUDAReplyTeradata DSA online backupThank you both for clearing up. Regarding archive loggs: Is there anyway we could run both FASTLOAD AND Backups parallely on the same objects?          Trouble is DBC ne...
5819905 Jul 2016 @ 10:44 PDTfeinholzToolsReplyTPT load failure on Interval datatype - Error code 7452I am not sure why users fail to provide us with the version of TPT they are using when reporting issues, but since you are loading data into Teradata 15.10, I am assuming that the version of TPT is...
5819805 Jul 2016 @ 10:35 PDTfeinholzToolsReplyTPT Failure: TPT Data connector Error "TPT_DATACONNECTOR_OPERATOR[1]: TPT19015 TPT Exit code set to 4." for FastLoad JobThe messages to which you refer are not "errors":   TPT_DATACONNECTOR_OPERATOR[1]: TPT19015 TPT Exit code set to 4. TPT_DATACONNECTOR_OPERATOR[1]: TPT19229 406 error rows sent to...
5819705 Jul 2016 @ 10:00 PDTFredDatabaseReplyNeed help on writing teradata stored procedurePut the entire SQL statement in a variable, and dynamically execute it: SET MYQUERY='CREATE TABLE ...'||CASE WHEN LOAD_TYPE='HISTORY' THEN ' WHERE...' ELSE '' END||...
5819605 Jul 2016 @ 10:00 PDTmjlocatAsterTopicAutomating grants in AsterWe have implemented both data roles and user roles in Aster. I wanted to create some way to make it easy for users to apply the proper grants to their tables when they're ready to allow others ...
5819505 Jul 2016 @ 08:41 PDTBlamey4DatabaseReplyPivot or Union All Help What data looks like AUTH_PROF_CDE SYS PRIN AGNT AUTH_CDE_TYP EQP_TYP HEAD_END_CDE EQP_PROTOCOL AUTH_CDE VSC52 8,495 6,000 0 S K...
5819405 Jul 2016 @ 08:40 PDTBlamey4DatabaseTopicPivot or Union All HelpNeed help with pivot or union please. My table has the fillowing columns Autho_Prof_Cde   Sys Prin Agnt Eqp_Typ Head_End_Cde Eqp__Protocol ...
5819305 Jul 2016 @ 07:59 PDTsg186097AsterTopicLoading JSON to ASTERHi I have Aster express on my desktop and would like to upload JSON objects from a file to a Table on ASTER. Datatype JSON is not supported, and I tried using VARCHAR, but it did not work. JSON go...

Pages