All forum activity

#DateUserForumTypeThreadPost
5774114 Jun 2016 @ 10:08 PDTfeinholzToolsReplyCan TPT be used to load file with 10M records of 3500 attributes ???Please explain what you mean by "attributes"? Will each field in the delimited file be loaded into a column of a table in a Teradata Database? An example of a record from the file would...
5774014 Jun 2016 @ 09:01 PDTsmantryConnectivityReplyCommand line installation for ODBC Driver for Windows 15.00.00.00I could not find any documentation which can help me in deploying the ODBC Suite silently. Can anyone guide me to the right direction ?
5773914 Jun 2016 @ 08:09 PDTCarlosALDatabaseReplyIs it an ordering - How do I generate a column that gives me the seq no of the selectHi. SQL SELECT does NOT guarantee (even in Oracle) any order of the rows returned if no ORDER BY clause is used. The Oracle ROWID does not provide an order of insertion. It is related t...
5773814 Jun 2016 @ 07:02 PDTmario_rozarioToolsReplyTPT Data Connector Error reading JSONHas this issue been resolved?  I am still facign the same issue. Here is my code: -  DEFINE JOB LOAD_JSON_FROM_FILE DESCRIPTION 'Load file using inserter operator' ( /**...
5773714 Jun 2016 @ 07:01 PDTcelinexuDatabaseTopicAsk help regarding to TOP, Rank and Partition Hi, I am new to Teradatabase and try to adapt my way into it. I am a data analyst not a developer.  Say I have a database as follow Table name is TRS PK sku   store  price&n...
5773614 Jun 2016 @ 06:51 PDTh.r.thejas@gmail.comToolsTopicTDCH-TPT InterfaceHey Guys,                      I was trying to export a large table from Teradata to HDFS as a textfile using TDCH-TPT Interface i was able t...
5773514 Jun 2016 @ 06:50 PDTGTeradataJobsReplysoftware Training Please share it to gaurav.malbari@gmail.com
5773414 Jun 2016 @ 06:41 PDTGTeradataGeneralReplyinterview helpHi Anand,   Please send it to gaurav.malbari@gmail.com
5773314 Jun 2016 @ 06:07 PDTsachinsDatabaseReplyDegraded Query performance while performing insertionHi, Please find below the DDLs of the source and target tables. 1) Source Tables(JEDI_CDW_DB.CALL_HIST and JEDI_AGR_DB.CDR_COST_HIST_PRE) 2) Target table - JEDI_AGR_DB.CALL_DAY_IMAGE_1 DDL of J...
5773214 Jun 2016 @ 04:59 PDTSrividhya80_bDatabaseReplyIs it an ordering - How do I generate a column that gives me the seq no of the selectThanks. I thought so. There was a rowid column that is no longer available. Can someone help me understand why? Is it to do with mpp architecture?
5773114 Jun 2016 @ 04:46 PDTyuvaevergreenDatabaseReplyIs it an ordering - How do I generate a column that gives me the seq no of the selectRowid cannot be retrieved like Oracle afaik..
5773014 Jun 2016 @ 04:39 PDTyuvaevergreenDatabaseReplyDegraded Query performance while performing insertionCan you post the ddls of the lookup and the source tables...
5772914 Jun 2016 @ 04:35 PDTchungtqDatabaseTopicGetting junk values for Latin column when using JDBCHi, I have a table with some LATIN column as following: CREATE SET TABLE Data_Produkty ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( ...
5772814 Jun 2016 @ 04:32 PDTyuvaevergreenDatabaseReplyRetrive data from tableUse the condition....where empid is not null or partyid is not null
5772714 Jun 2016 @ 03:44 PDTChiraggorsiaDatabaseTopicSpool in which volatile table lies.Hi, Is it possible to find the spool number in which volatile table lies? Regards, Chirag  
5772614 Jun 2016 @ 03:40 PDTChiraggorsiaViewpointReplyNegative Spool in ViewpointHi Carlos, Thanks for you answer. But can you please update on what is Phantom / Orphan spool, Or do you have a link where I can read about it?  Regards, Chirag  
5772514 Jun 2016 @ 02:48 PDTSrividhya80_bDatabaseTopicIs it an ordering - How do I generate a column that gives me the seq no of the select Hi All I have the following table CREATE MULTISET TABLE HASH_V ,FALLBACK ( hashVal INTEGER ) PRIMARY INDEX ( hashVal ); --data inserted in this order insert into HASH_V val...
5772414 Jun 2016 @ 02:41 PDTsachinsDatabaseTopicDegraded Query performance while performing insertionHi Friends, I have one query as below where we are performing an insertion in one empty table. The insertion statement is as below.The below insertion query is currently taking more than 20 hrs fo...
5772314 Jun 2016 @ 02:36 PDTyuvaevergreenGeneralReplyto remove duplicatesCan you post some sample data
5772214 Jun 2016 @ 02:30 PDTSramDatabaseTopicRetrive data from tableHi team, I have table A with four fields Empid,ename,salary,partyid. i want to fetch data from table a where atleast of one of field Empid or Partyid should be not null value. if both fields are ...
5772114 Jun 2016 @ 02:24 PDTyuvaevergreenDatabaseReplyPerformance on having more than 30 Left outer joinvolume of the lookup tables?...
5772014 Jun 2016 @ 02:17 PDTyuvaevergreenDatabaseReplyConvert text to a timestampCAST(CAST(TO_TIMESTAMP(OREPLACE('June 07,2016,HOUR 1','HOUR',''),'MONTH dd,yyyy,HH24') AS VARCHAR(19)) AS TIMESTAMP(0))
5771913 Jun 2016 @ 11:04 PDTnimish_123DatabaseTopicTrigger logThere are DELETE/INSERT and UPDATE trigger defined on a table but when i am deleting or inserting record the expected action is not happening. How can i confirm the if trigger fired or not? Is ther...
5771813 Jun 2016 @ 07:56 PDTMarkJBrayshawViewpointReplyViewpoint Datalabs - 'non existant user' logon faiureThank you I'll follow that up with support
5771713 Jun 2016 @ 06:02 PDTVishnujpDatabaseReplyCurrent date as column name in select queryThe output looks like this Current_date 16

Pages