28 | 30 Aug 2016 @ 10:36 PDT | Tools | Reply | Can TTU 14.10 on Linux connect on a15.10 RDBMS | Informatica 9.6.1 probably? Some story here. TTU 14.10 is 2 versions upward compatible (excluding new features in newer versions ofcourse). So 15.00 and 15.10 are supported, but 16.00 (not out yet)... |
27 | 19 Aug 2016 @ 01:24 PDT | General | Reply | Disable Logging in TPT | The script/program that calls the TPT also specified the logging and the detail of the logging. You need to look into that.
|
26 | 17 Aug 2016 @ 03:54 PDT | Teradata Studio | Reply | How to solve the error "Creating connections to local Teradata Database has encountered a problem" ? | The first user on the database is dbc/dbc. Is that what you are looking for?
|
25 | 16 Aug 2016 @ 10:54 PDT | Database | Reply | Creating a snapshot from Type 2 behaviour | I remember that the INTERVAL function could be usefull. This prevents a product join to your calendar dimension. We ended up with making the tables physical for maximum performance and to make it e... |
24 | 11 Aug 2016 @ 11:32 PDT | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | SELECT GREATEST(50,100,70)
|
23 | 11 Aug 2016 @ 11:32 PDT | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | WHAT does not work.
Given the example data for id 4 the statement returns 100:
|
22 | 09 Aug 2016 @ 11:05 PDT | Database | Reply | Merge the continuous rows with date range( sequential rows should merge) | this topic did help me in the past:
https://forums.teradata.com/forum/general/need-help-merging-consecutive-and-overlapping-date-spans
i ended up using dnoets olap function (how typical). however... |
21 | 09 Aug 2016 @ 10:53 PDT | Data Modeling | Reply | AJI creation for a single high priority query | SAP data... Microstrategy... naming convention like that of TAS solution from Teradata... cool!
is a sparse ji also a solution? on spend = Y with a partitioning on fiscal period name.
by the way:... |
20 | 08 Aug 2016 @ 11:09 PDT | General | Reply | Improve performance on an analytical query , mulitple columns using same set of partitions | And what would a simple sum/group by do? I sometimes think that an analytical fuction is executed seperately. It is cool stuff, sometimes performs like crazy. But in some case it doesn't.
|
19 | 06 Aug 2016 @ 04:57 PDT | Database | Reply | User's DDL | Maybe, but I did not check, the new Teradata Studio can generate the SQL for you.
|
18 | 06 Aug 2016 @ 04:55 PDT | Teradata Database on VMWare | Reply | ODBC on Teradata on VM | If I remember it correct tdicu is listed as a dependency for tdodbc, but I never installed it. tdicu is for some language dependend messages. We stayed on English and no problems so far.
|
17 | 21 Jul 2016 @ 05:28 PDT | Database | Reply | Problems installing in TDExpress15.00.02_Sles11_40GB | Afaik is Data Services most of the time installed on Windows. The DS Designer tool runs only on Windows?
|
16 | 19 Jul 2016 @ 10:42 PDT | Viewpoint | Reply | Moving Data from One Viewpoint Server to a new Viewpoint Server | If you want to move everything: move everything in the /backup folder to the new server in the /backup folder there and restore the data/configuration. The restore process is described in chapter 6... |
15 | 18 Jul 2016 @ 02:10 PDT | Database | Reply | How to CREATE TABLE(copy) without any index and parititions present on source table | I stand corrected ;-)
|
14 | 18 Jul 2016 @ 02:08 PDT | Connectivity | Reply | connecting to Teradata from Oracle DB &SAP BW | Yes this is possible with a product from the Teradata SAP COE. TVAS/TELS the product was called. But you need to contact them.
|
13 | 15 Jul 2016 @ 08:39 PDT | Tools | Reply | TPT Export vs Fast Export | They are the same except Fast Export is legacy and TPT is the future.
|
12 | 15 Jul 2016 @ 08:38 PDT | Database | Reply | How to CREATE TABLE(copy) without any index and parititions present on source table |
CREATE TABLE UDWETLWORK_D5.MBR_COV_TST_tmp AS
(
SELECT * FROM UDWETLSANDBOX.ADJD_MCE_TST
) WITH NO DATA
WITH PRIMARY INDEX (FIELD1, FIELD2);
This should work
|
11 | 13 Jul 2016 @ 11:25 PDT | Tools | Reply | TPT deadlock Issue. | 15.00/15.10 has several improvements around locking for TPT: dbc.accessrights has another PI and there is the partition level locking.
I strongly suggest that you familiarize yourself with the new... |
10 | 11 Jul 2016 @ 12:34 PDT | Viewpoint | Reply | Viewpoint SUSE Compatibility | VP 15.10 is compatible with SLES10. VP15.11 is only SLES11.
Why not upgrade to SLES11/VP15.11?
|
9 | 22 Jun 2016 @ 01:02 PDT | Analytics | Reply | CPU disk ratio error from 'like' statements | Probably the like statements results in a full table scan and thus a high io/cpu estimate.
Here the effect is a bit explained:
http://www.dwhpro.com/teradata-indexing-2/
|
8 | 16 Jun 2016 @ 01:35 PDT | Connectivity | Reply | ODBC performance on Linux | No-one?
|
7 | 10 Jun 2016 @ 12:01 PDT | Database | Reply | Seeing Junk character when inserting hyphen (-) | The utf-8 session recommendation I knew, but the detailed explanation why in this case it is going wrong... wow.
Beside that: don't query DBC.TABLES, but query DBC.TABLESV if available on your... |
6 | 09 Jun 2016 @ 11:58 PDT | Database | Reply | DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE | SELECT DATE returns the current date from the database/OS. I guess your VM date/time is not up-to-date...
|
5 | 09 Jun 2016 @ 11:57 PDT | Database | Reply | Current date as column name in select query | Set the alias between double quotes: AS "CURRENT_DATE"
|
4 | 08 Jun 2016 @ 11:12 PDT | Database | Reply | Multi-level partition or differently partitioned JI? | Hi Dieter,
The reporting guys are complaining that it is "difficult" for them to present a year-week number in the report, and in the SQL select on the date... So changing the SQL from t... |