#DateForumTypeThreadPost
51924 Jul 2016 @ 05:20 PDTAnalyticsReplyQUERY 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...
51821 Jul 2016 @ 05:42 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBYes, I agree with Johannes, You can install the DS cleint on windows and access the teradata on VM using ODBC.  
51721 Jul 2016 @ 04:21 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBThe minimum patch level required for SAP DS is 2. Please be very carefull,as updating the patch may disturb the Teradata configuration on VM. You can follow the below link to update the patch leve...
51621 Jul 2016 @ 03:52 PDTAnalyticsReplyQUERY IN ASTER Before running a query, you must have a running instance of Aster. have you configured the Aster VM?
51520 Jul 2016 @ 02:03 PDTAsterReplyAster 6.0 to HDP 2.1 select does not workHi, It seems to be a problem from Cloudera. have you made any upgrade to Cloudera server? Are you able to ping the server 'smp200-8_eth4' from Aster machine?  
51420 Jul 2016 @ 01:39 PDTDatabaseReplyFastload Duplicate Records issuesAs you told earliar the fastload script got aborted. Fastoad only load into an empty table.  Can you check if there is no data in the Target table? Otherwise the best option is to use NOPI t...
51320 Jul 2016 @ 12:35 PDTDatabaseReplyFastload Duplicate Records issuesHi, Fastload do not load full row duplicate records, rather put them in a separate error table by default.  As per the log, there are 5 duplicates but no dups in error table, So one reason c...
51219 Jul 2016 @ 07:06 PDTToolsReplyTPT - ScriptingYou can use template and wrtie a macro or SP to take input the table name or loop through list of tables and generate TPT script against each table.
51118 Jul 2016 @ 01:04 PDTToolsReplyEncryted Password File for FastExportHave you made any update to AIX ?
51018 Jul 2016 @ 09:58 PDTToolsReplyEncryted Password File for FastExportWhat do you mean by reenter?  If you have tdwallet installed, simply run the tdwallet, add entries and use them in script as given in the example.  
50915 Jul 2016 @ 02:42 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableHi, There is no need to write WITH PRIAMRY INDEX, WITH is required for NO PRIMAARY INDEX. Normall Syntax is: CREATE TABLE UDWETLWORK_D5.MBR_COV_TST_tmp AS ( SELECT * FROM UDWETLSANDBOX.ADJD_M...
50815 Jul 2016 @ 05:53 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source table CREATE VOLATILE TABLE TABLE_NAME AS ( SELECT * FROM EXISTING_TABLE ) WITH NO DATA NO PRIMARY INDEX;  
50715 Jul 2016 @ 05:21 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableHi, You can create a NOPI Global temporary or volatile table in your script. Create Volatile Table TableName (......) NO PRIMARY INDEX Khurram
50615 Jul 2016 @ 05:05 PDTToolsReplyEncryted Password File for FastExportHere is an example you can follow: https://forums.teradata.com/forum/tools/teradata-wallet-0   Khurram
50515 Jul 2016 @ 02:43 PDTAsterReplyAster Visualization SpacingHi, Apparently, it seems to be an issue of your broswer as the visualiation is working fine in IE. You can also try the same in FireFox. Otherwise, in visuliation settings you will look for the p...
50415 Jul 2016 @ 02:33 PDTToolsReplyEncryted Password File for FastExportYou can use teradata Wallet if it is available. It stores encrypted password, and you will not write the password directly in script. Khurram
50315 Jul 2016 @ 02:26 PDTAnalyticsReplyCoverting Char to DateBonjour, Ceci est déjà répondu à https://forums.teradata.com/forum/enterprise/to-check-is-a-string-is-numeric-or-not Khurram  
50214 Jul 2016 @ 07:07 PDTDatabaseReplyAdvice on ELT process pleaseHi, If you already have SQL scripts prepared, the best & quick way is to use BTEQ scripts. You can simply embed the existing SQL scripts in BTEQ, use BTEQ Conditional logic & error handlin...
50114 Jul 2016 @ 02:13 PDTToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colorsThank you for sharing the workaround. 
50014 Jul 2016 @ 02:02 PDTDatabaseReplyNOT IN and nested queryTry this: Sel distinct col1 from table1 where col1 NOT IN (Sel col11 from table11 where col11 is not null group by 1);  
49914 Jul 2016 @ 01:58 PDTDatabaseReplyNeed to generate a row number like column SELECT LOCATION, ORDER_ID, CLASS, DATE, ROW_NUMBER() OVER (PARTITION BY LOCATION, ORDER_ID ORDER BY DATE) AS RANK FROM TABLE_NAME  
49814 Jul 2016 @ 01:55 PDTDatabaseReplyALTER_PPIHi Katei, Just create a new table with new partition layout, and do insert select into new table. It will not take much time. Khurram
49714 Jul 2016 @ 01:52 PDTDatabaseReplyAvoid all-row scan in driving table using NUSIHi, To use NUSI, the indexed column should be used in WHERE condistion. Since you have placed no restrcition on any of the tables, it will obviously go for full table scan. Khurram
49612 Jul 2016 @ 05:09 PDTDatabaseReplyFaster way to delete and rebuild a tableHi, Thank you for clarification, but these all first 6 steps will lead the table B in same state as it is in initial state. So you can directly add the new data to table B without these steps. Jus...
49512 Jul 2016 @ 03:49 PDTDatabaseReplyStoring History DAta into tablesThe table design seems to be OK, if this BA_GENL_ID is unique you can make the PI as UPI to have more faster access. Also, you have used lot of compression, it may slow down the access time, is it...

Pages