419 | 30 Jan 2014 @ 12:35 PST | Database | Reply | FORMAT option in create table | Hi,
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?
|
418 | 30 Jan 2014 @ 12:25 PST | Database | Reply | Aggregated Join Index on 2 systems | Hyma,
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... |
417 | 24 Jan 2014 @ 04:38 PST | Cloud Computing | Reply | No internet connection in VMWARE | Raja,
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... |
416 | 23 Jan 2014 @ 11:57 PST | Database | Reply | Formatting CURRENT_TIMESTAMP |
select CAST((current_timestamp(0) (format 'YYYYMMDDHHMISS')) AS VARCHAR(14))
|
415 | 23 Jan 2014 @ 12:50 PST | Database | Reply | SQL statements in UNION executes serial or parallel | Bikky,
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... |
414 | 22 Jan 2014 @ 10:08 PST | Cloud Computing | Reply | No internet connection in VMWARE | Raja,
Dont you have Internet Protocol Version 4( TCP/IPv4) properties in guest machine?
|
413 | 22 Jan 2014 @ 09:34 PST | Database | Reply | Getting week of the year from a date | You 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... |
412 | 22 Jan 2014 @ 04:17 PST | Cloud Computing | Reply | No internet connection in VMWARE | Raja,
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.
|
411 | 22 Jan 2014 @ 01:06 PST | Database | Reply | Which 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... |
410 | 22 Jan 2014 @ 12:59 PST | Database | Reply | When to use Temporal features | hi,
Temporal is a physical database desgin concept and you will have to decide at design time which table will be designed using Temporal feature.
|
409 | 22 Jan 2014 @ 12:56 PST | Cloud Computing | Reply | No internet connection in VMWARE | Raja,
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... |
408 | 17 Jan 2014 @ 01:17 PST | Database | Reply | Index Question | Tclear,
You can create PI on Item, and secondary indexes on Item/origin, item/destination to have optimal access.
|
407 | 15 Jan 2014 @ 10:57 PST | Database | Reply | Getting week of the year from a date |
SELECT TD_SYSFNLIB.WEEKNUMBER_OF_YEAR (CURRENT_DATE);
|
406 | 15 Jan 2014 @ 10:50 PST | Database | Reply | Teradata Max Across Multiple Columns | Hi,
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... |
405 | 15 Jan 2014 @ 04:20 PST | Database | Reply | Account balance SQL | try 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... |
404 | 15 Jan 2014 @ 03:02 PST | Database | Reply | Account balance SQL | Ok, 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... |
403 | 15 Jan 2014 @ 02:51 PST | Database | Reply | New Features in Teradata 14 | Check this out:
http://teradatastudents.blogspot.com/2012/07/teradata-14-new-features.html
|
402 | 15 Jan 2014 @ 02:50 PST | Database | Reply | Account balance SQL | Hi 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... |
401 | 14 Jan 2014 @ 02:18 PST | Database | Reply | SQL help | Nilesh,
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 ... |
400 | 09 Jan 2014 @ 08:45 PST | Database | Reply | Inserting multiple values with single quotes in single field | Sunny,
Have you tried Raja's solution? I think the double qoutes will not be inserted instead the single qouted string will be added.
|
399 | 09 Jan 2014 @ 03:36 PST | Tools | Reply | Cpu skew of Fastload | Hi 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... |
398 | 09 Jan 2014 @ 03:27 PST | General | Reply | Teradata Database software | Hi 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... |
397 | 08 Jan 2014 @ 08:56 PST | Database | Reply | OREPLACE | 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... |
396 | 08 Jan 2014 @ 08:52 PST | Tools | Reply | Delimiter Issue With TPT on Linux Platform | Hi DKing,
Can you please tell which delimiter is causing issue?
|
395 | 08 Jan 2014 @ 08:49 PST | Database | Reply | Date partitioned tables | Hi 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... |