All forum activity

#DateUserForumTypeThreadPost
5869424 Jul 2016 @ 10:04 PDTSoumyatgDatabaseReplyMerge into operationThanks Khurram, but as I understand that apart from the NUPI for the join  condition, need to specify a unique set of columns(like a Primary key) for merge operation. In my case there is no se...
5869324 Jul 2016 @ 09:15 PDThanx5520ToolsTopiccan not download presto JDBC/ODBC client package Hi, I cannot download client package from the following link, I can only download a 6 byte file. Can somebody help me? Thank you in advance. http://www.teradata.com/Presto-Download-Get-Started/?La...
5869224 Jul 2016 @ 05:35 PDTsrjilekToolsTopicSQL Error highlighting w/.Net connector not working (SQL Assistant v15) I've got 2 installs of SQL Assistant, and neither are highlighting the error line when running queries, and I'm using the .Net connector.  One of them is the latest version, and a c...
5869124 Jul 2016 @ 02:30 PDTfgrimmerTeradata StudioReplyKerberos AuthenticationSudarmo, There should be a link at the bottom of the 'Creating a Teradata Connection' page, under Database Connectivity>Teradata Connection Profile. I am not seeing this in our latest re...
5869024 Jul 2016 @ 02:17 PDTfgrimmerTeradata StudioReplyTeradata 15.1 Error when trying to execute query@gtmmaj, What version of Studio are you using? This issue should be resolved in our latest 15.11 release.
5868924 Jul 2016 @ 06:55 PDTM.Saeed KhurramDatabaseReplyMerge into operationYou can read this thread it will answer your question. http://datawarehouse.ittoolbox.com/groups/technical-functional/teradata-l/merge-with-nupi-index-4742107
5868824 Jul 2016 @ 06:44 PDTM.Saeed KhurramDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBTeradata 15.10 VM can be downloaded from here: http://downloads.teradata.com/download/database/teradata-express-for-vmware-player You can check the patch level from VM if it is 2 then you can eas...
5868724 Jul 2016 @ 06:30 PDTM.Saeed KhurramAsterReplyAster database/schema/table space managementHi, This is infact a very interesting question. I have gone through all the Manuals of Aster but didn't find any rules for space management. The database are created without any parameters for...
5868624 Jul 2016 @ 06:08 PDTM.Saeed KhurramToolsReplyInstalling Teradata ODBC on AIXHi, You can get these components individually from Teradata At Your Service i.e. https://tays.teradata.com/ If your customer do not have an account at Tays, they can get an account from Tera...
5868524 Jul 2016 @ 05:20 PDTM.Saeed KhurramAnalyticsReplyQUERY IN ASTER Hi, Use the below format to create table: CREATE FACT TABLE users_young_northamerica ( userid INT, name VARCHAR, email VARCHAR, age SMALLINT, favorite_color CHAR(5), region_id INT ) DIS...
5868424 Jul 2016 @ 02:52 PDTpradip_rangDatabaseReplyDefaulting during Teradata table loading through fast load Thanks Fred .... :)
5868323 Jul 2016 @ 08:51 PDTNavicDatabaseTopicData migration between 2 different BoxesHello! Our team is working in migrating data of few databases from one server to another server which are in different locations. Possibality of data movement  throug...
5868223 Jul 2016 @ 03:02 PDTjgcortesConnectivityReplyODBC Connection Error - Specified driver could not be loadedHi, I'm trying to use Teradata based on ODBC, but I have this error 0: Loading the Teradata ICU Library Failed. Error is: 126 any suggestion?
5868123 Jul 2016 @ 09:52 PDTdnoethDatabaseReplyCreate a table with a date column that has a defaultTO_DATE exists in Teradata since TD14 (2012), before it was available as a C-UDF.
5868023 Jul 2016 @ 08:50 PDTagnit.chatterjee1988DatabaseReplyCreate a table with a date column that has a defaultTO_DATE is oracle specific function not supported in Teradata.
5867923 Jul 2016 @ 03:36 PDTjester666Teradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)The same issue for me. Any Teradata ami's at AWS could not pass checks after launching. It goes on for 9 days. Instances that had been  launched before 9 days ago are working fine. Please...
5867822 Jul 2016 @ 11:49 PDTKNToolsReplyDetermine #sessions to set for load / exp jobsFred i thought the general calculation applies to the FEXP as well... Just wanted to understand if i have 2 seperate System across continents and if a Business( based in Aus ) is tr...
5867722 Jul 2016 @ 11:36 PDTKNToolsReplyTPT - ScriptingThank you Steve.. I did give a try to make use of TDLOAD and it worked wonderfully well.. I was able tto see that the TDLOAD picked up update operator when the i had the target table with SI.. and ...
5867622 Jul 2016 @ 07:56 PDTreachrajmit@yahoo.comHadoopTopicPOM.xml for mapreduce development - "Hadoop 2.7.1.2.3.2.0-2950"Hi - My organization uses Hadoop 2.7.1.2.3.2.0-2950. I am new to whole hadoop and mapreduce programming. I am looking for POM.xml for mapreduce program development. is there seperate reposito...
5867522 Jul 2016 @ 02:22 PDTpmooshTeradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)Any way you could add cloud init to the image? :-)
5867422 Jul 2016 @ 01:26 PDTskydve76DatabaseReplyMerge wont run with dbc.SysExecSQL MERGE INTO  D_CUL_CR_VW.V_OFFER_M  AS TGT USING (SELECT OFFER_ID,OFFER_ROW_SEQ_ID,AUTHORIZATION_ID,XREF_AGREEMENT_ID,ORIGINAL_AUTHORIZATION_ID,BASIC_DATA_INCOMPLETE_FLAG,NINE_DIGIT_KEYL...
5867322 Jul 2016 @ 01:25 PDTskydve76DatabaseReplyMerge wont run with dbc.SysExecSQL MERGE INTO  D_CUL_CR_VW.V_OFFER_M  AS TGT USING (SELECT OFFER_ID,OFFER_ROW_SEQ_ID,AUTHORIZATION_ID,XREF_AGREEMENT_ID,ORIGINAL_AUTHORIZATION_ID,BASIC_DATA_INCOMPLETE_FLAG,NINE_DIGIT_KEYL...
5867222 Jul 2016 @ 01:24 PDTskydve76DatabaseTopicMerge wont run with dbc.SysExecSQL MERGE INTO  D_CUL_CR_VW.V_OFFER_M  AS TGT USING (SELECT OFFER_ID,OFFER_ROW_SEQ_ID,AUTHORIZATION_ID,XREF_AGREEMENT_ID,ORIGINAL_AUTHORIZATION_ID,BASIC_DATA_INCOMPLETE_FLAG,NINE_DIGIT_KEYL...
5867122 Jul 2016 @ 12:59 PDTFredToolsReplyFloat data type export using Fast ExportFLOAT values are NOT "rounded off to 15 digits", nor is this specifically a Teradata issue. While some numbers (such as whole numbers with fewer digits) can be represented exactly, float...
5867022 Jul 2016 @ 12:08 PDTFredDatabaseReplyReal/DoublePrecision/FLoat type in TeradataYou can use the keyword REAL or DOUBLE PRECISION in the CREATE TABLE; the resulting column data type will be FLOAT.

Pages