#DateForumTypeThreadPost
41930 Jan 2014 @ 12:35 PSTDatabaseReplyFORMAT option in create tableHi,   Which version of teradata you are running? I have tested it on 14 and the same statement works fine. Can please tell what error actually you are facing?  
41830 Jan 2014 @ 12:25 PSTDatabaseReplyAggregated Join Index on 2 systemsHyma, Optmizer makes its decisions based on many factors; it considers system configurations, stats, sql code, data demographics etc. So on one machine it might consider JI as a faster approach, a...
41724 Jan 2014 @ 04:38 PSTCloud ComputingReplyNo internet connection in VMWARERaja,   Basically, I was talking about windows host and windows guest configuration. I have not tested it on linux. The main thing is the same default gateway for both the machines. You...
41623 Jan 2014 @ 11:57 PSTDatabaseReplyFormatting CURRENT_TIMESTAMP select CAST((current_timestamp(0) (format 'YYYYMMDDHHMISS')) AS VARCHAR(14))  
41523 Jan 2014 @ 12:50 PSTDatabaseReplySQL statements in UNION executes serial or parallelBikky, It is a decision made by the optimizer based on several factors. Optimizer decides whether to execute statements sequentailly or parallel.  the statements independent of each other ar...
41422 Jan 2014 @ 10:08 PSTCloud ComputingReplyNo internet connection in VMWARERaja,   Dont you have Internet Protocol Version 4( TCP/IPv4)  properties in guest machine?  
41322 Jan 2014 @ 09:34 PSTDatabaseReplyGetting week of the year from a dateYou can find the complete info about this function at this link, and can use the appropriate syntax. http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/SQL_Reference/B035_1145_111A/Business_Calend...
41222 Jan 2014 @ 04:17 PSTCloud ComputingReplyNo internet connection in VMWARERaja,   Yes, login to guest machine, and assign IP as you do on any machine by going to network settings. On host, go to VMNET1 properties and assign Ip as described above.  
41122 Jan 2014 @ 01:06 PSTDatabaseReplyWhich is efficient?Parteek, The first version will be better. The reason is to get performance you need to reduce IO as much as you can. While selecting from tables, if you select only columns requied and restrict r...
41022 Jan 2014 @ 12:59 PSTDatabaseReplyWhen to use Temporal featureshi, Temporal is a physical database desgin concept and you will have to decide at design time which table will be designed using Temporal feature.  
40922 Jan 2014 @ 12:56 PSTCloud ComputingReplyNo internet connection in VMWARERaja, You can use Host option in vm ware network settings, instead of NAT, Bridged. Once done, start your vmware and assign statics IP to guest. for example for guest: XXX.XXX.30.10 in gateway...
40817 Jan 2014 @ 01:17 PSTDatabaseReplyIndex QuestionTclear, You can create PI on Item, and secondary indexes on Item/origin, item/destination to have optimal access.  
40715 Jan 2014 @ 10:57 PSTDatabaseReplyGetting week of the year from a date SELECT TD_SYSFNLIB.WEEKNUMBER_OF_YEAR (CURRENT_DATE);  
40615 Jan 2014 @ 10:50 PSTDatabaseReplyTeradata Max Across Multiple ColumnsHi, I have not tested this but I hope it will work for you. SELECT CUSTOMER, NUMBER, MAX(DATE) OVER(PARTITION BY NUMBER ORDER BY DATE DESC) AS MAX_DT, MAX(TIME) OVER(PARTITION BY NUMBE...
40515 Jan 2014 @ 04:20 PSTDatabaseReplyAccount balance SQLtry this: SEL cdate, MIN(BAL) FROM TABLENAME, Sys_Calendar.CALDATES WHERE cdate BETWEEN DATE '2014-01-01' AND DATE '2014-01-10' GROUP BY cdate UNION SEL cdate, MAX(BAL) FRO...
40415 Jan 2014 @ 03:02 PSTDatabaseReplyAccount balance SQLOk, You want to repeat these values for all dates, is there any specific criteria for repitition OR we can repeat in random fashion like for first 10 days it can 10k and then for next 10 days 15k a...
40315 Jan 2014 @ 02:51 PSTDatabaseReplyNew Features in Teradata 14Check this out: http://teradatastudents.blogspot.com/2012/07/teradata-14-new-features.html  
40215 Jan 2014 @ 02:50 PSTDatabaseReplyAccount balance SQLHi Koushik,   What I get from your question, you can use the following simple select. SELECT A_DATE, A_BAL FROM TABLE NAME WHERE A_DATE BETWEEN DATE '01-01-2014 AND DATE '31...
40114 Jan 2014 @ 02:18 PSTDatabaseReplySQL helpNilesh, When you use BETWEEN 3 PRECEDING AND 3 PRECEDING it means that a single third row preceding the current row will be selected. So in your case when you are at ...
40009 Jan 2014 @ 08:45 PSTDatabaseReplyInserting multiple values with single quotes in single fieldSunny, Have you tried Raja's solution? I think the double qoutes will not be inserted instead the single qouted string will be added.   
39909 Jan 2014 @ 03:36 PSTToolsReplyCpu skew of FastloadHi Volvox, Every loading process consumes system resources in the form of CPU, Memory, and disk space. CPU intensive workload will obviously use more CPU, and during loading a lot of IO is being p...
39809 Jan 2014 @ 03:27 PSTGeneralReplyTeradata Database softwareHi Bikky,   Previously 32 bit Teradata Express version was available to install on any machine. But with TD 14 release, the express edition is being provided only installed in VM Ware or Ama...
39708 Jan 2014 @ 08:56 PSTDatabaseReplyOREPLACE Dieter, I am surprized to know that, is there any enhancement in Teradata to define a column with 8000 varchar? AFAIK a varchar can be defined upto 64000, and in case of unicode this limit is red...
39608 Jan 2014 @ 08:52 PSTToolsReplyDelimiter Issue With TPT on Linux PlatformHi DKing, Can you please tell which delimiter is causing issue?  
39508 Jan 2014 @ 08:49 PSTDatabaseReplyDate partitioned tablesHi Praveen, There is a DBC view available named dbc.indexconstraints. You can use this view to get all the partitioned table names. The partitioned tables have a constrainttype of 'Q'. The...

Pages