#DateForumTypeThreadPost
4020 Mar 2014 @ 11:39 PDTToolsReply Issue while loading space delimited flat file using fastload on TPTCan you skip the first row and try. i believe the header is also being read
3920 Mar 2014 @ 11:27 PDTDatabaseReplyApplying OLAP functions on hashrow applied column SELECT cast(HASHBUCKET(hashrow(1234,5))as varchar(10)) we can convert a byte datatype into an integer only using the hashbucket which can be later casted into a varchar.
3820 Mar 2014 @ 10:23 PDTDatabaseReplyneed sql help.. sel a.cat,(a.shoppers-b.shoppers),(a.trans-b.trans),(a.price-b.price),(a.units-b.units),(a.cost-b.cost),(a.adj-b.adj) from (SELECT 'TY' as YR, CAT_SEGMENT as Cat, Count...
3719 Mar 2014 @ 11:09 PDTGeneralReplySyntax error 3706  is this the full query,  this appears to be only part of the query. is there a from clause prior to the initial bracket. The above query should work fine. you cannot start the query wi...
3617 Mar 2014 @ 11:40 PDTToolsReplySQL ASSISTANTThey can be ran from your client but not from SQL Assistant
3517 Mar 2014 @ 11:36 PDTDatabaseReplyCalculating day number of the year for a date sel  (case (current_date mod 10000)/100      when 1  then current_date mod 100      when 2  then current_date mod 100 + 31   &n...
3417 Mar 2014 @ 11:12 PDTDatabaseReplyCalculating day number of the year for a date sel calendar_date,day_of_year from sys_calendar.calendar This gives the day of the year
3317 Mar 2014 @ 11:02 PDTDatabaseReplyHow is the Node DecidedThanks Dieter for the correction. Krishna  
3214 Mar 2014 @ 09:07 PDTDatabaseReplywhy we use sys_mgmt database in teradataDBC tables have the querylogs and other information if the logging is enabled. SYS_MGMT(PDCRINFO) is the database which holds the historical information for those which are present in DBC. Querying...
3112 Mar 2014 @ 10:43 PDTDatabaseReplycompression calculationsKishore, I believe Shashi is looking for MVC of the columns in a table, but not BLC of the table. @Shashi, Please let me know if otherwise. The best columns that would be candidates for MVC are t...
3012 Mar 2014 @ 10:23 PDTTeradata ApplicationsReply[Teradata][ODBC Teradata Driver][Teradata Database] Table/view/trigger name 'item' is ambiguousThis might be because when you logon to sql assistant, the default database might have been set to the database where the item table/view/trigger resides. Modify this to qualify 'item' with...
2912 Mar 2014 @ 10:20 PDTDatabaseReplyHow to restore perticular TABLE from backup location in TERADATA.you should be having the ABUGUI which works similar to TARAGUI. You can restore selected objects or all the objects. Instead of FILEDEF you can also give File=archive. Also you can try the COPY co...
2812 Mar 2014 @ 09:13 PDTGeneralReplyWant to reduce the Size of Access Rights TableThe rights at the role level are identified in the dbc.allrolerights table. The member and their roles can be identified in the dbc.rolemembers table. Thus you get what are the rights that are exis...
2712 Mar 2014 @ 08:46 PDTTeradata ApplicationsReplyFast Export for tables having more than 600 ColumnsPlease verify the length of the columns if there are any char columns please try to cast into varchar. Also i believe you are using  .export outfile /../datafile.csv MODE RECORD FORMAT TEXT; I...
2612 Mar 2014 @ 08:34 PDTToolsReplyFASTLOAD SCRIPT ISSUEHas this error occured when a restart of the job was done. if so clean out the error tables, restart log table and do a fresh restart.
2511 Mar 2014 @ 01:49 PDTDatabaseReplyHow is the Node DecidedI Second Blaine on the PI. When a table is created on Teradata platform, all the amps in the system will have the header information of the table which is not accessible to users except inter...
2411 Mar 2014 @ 01:35 PDTDatabaseReplyData update cost for table with lots of columns or only a few columnsDefinitely the processing and the IO consumed in this case will be more. Also it depends on the where clause conditions that you are using in the update query. Lets suppose you are  using a PI...
2311 Mar 2014 @ 01:20 PDTDatabaseReplyTransaction ABORTed due to Teradata table deadlock in InformaticaKanna, I am not sure if the same is the table that you are loading usinge multiple parallel sessions. If that is the case what Khurram suggested will help. But usually we see this situation in cas...
2211 Mar 2014 @ 12:05 PDTDatabaseReplyDate as Integerwhat are the columns that you think are changing in the table B versus A, you need to mention them as <> conditions in your update like Update B from A ST Set Efftctive_Date_tb=current_dat...
2111 Mar 2014 @ 11:53 PDTDatabaseReplyHow to restore perticular TABLE from backup location in TERADATA.Are you using Tara gui. if so you can generate it using Task>>Restore menu which will ask  for the table that you want to restore and the credentials. One you select that you can ask to ...
2011 Mar 2014 @ 11:00 PDTGeneralReplyHow to know AMPs and Nodes list from teradata database from working applicationSmarakaDas as you might be aware, we call the amps and PE's as virtual processors, they are considered to be virtual. For a particular configuration usually, the number of AMPS will always be f...
1910 Mar 2014 @ 09:54 PDTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemThis would be for combination of 3 shops. Notice that there would be 3 join conditions whn joining the 3 tables instead of 2 joins for 3 tables. With the limited data that i have, the result of thi...
1810 Mar 2014 @ 09:42 PDTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problem create table shop_list2 as( sel a1.shopnbr shop1,a2.shopnbr shop2,a3.shopnbr shop3 from shopping a1,shopping a2,shopping a3 where a1.shopnbr<>a2.shopnbr and a2.shopnbr<>a3.shopnbr a...
1710 Mar 2014 @ 09:36 PDTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problem shop1 shop2 Count(*) 3 2 6 2 3 6 1 4 6 3 1 6 4 1 6 1 3 6 4 3 5 3 4 5 1 2 4 2 1&n...
1610 Mar 2014 @ 09:30 PDTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problem create table shopping (ShopNbr integer,  Item integer)  primary index (shopnbr); insert into shopping values (1, 100); insert into shopping values (1  ,101); insert into s...

Pages