4453 | 20 May 2016 @ 07:37 PDT | Database | Reply | TIPS TO CONVERT DECIMAL TO VARCHAR | When you specify FORMAT = 'Delimited' in your TPT you don't have to cast every columns to VarChar, it's done automatically, but using default formats.
In your case you don&... |
4452 | 20 May 2016 @ 03:13 PDT | Database | Reply | Port MS SQL Cursor to Teradata | Most of the syntax can be converted easily (adding lots of semicolons), but returning the result of the counts is more complicated. You need an intermediate table to Insert the counts and then fina... |
4451 | 20 May 2016 @ 02:45 PDT | Database | Reply | Distribution Data Function/Solution | Ouch, your current aproach will product join Party and Channel.
When you can apply QUANTILE logic to your problem there's no more product join and the mapping should be more stable. Try this (... |
4450 | 20 May 2016 @ 01:55 PDT | Database | Reply | Macro vs Procedure - SQL SECURITY | Q1: No.
Q2: The database where the Macro is stored must have the necessary rights WITH GRANT OPTION.
|
4449 | 19 May 2016 @ 05:39 PDT | Teradata Studio | Reply | Unable to launch Teradata Studio Express | Hi Arpita,
Teradata Studio is only a database client used to connect to a database server.
The server might be Teradata Express VM
http://downloads.teradata.com/download/database/teradata-e... |
4448 | 19 May 2016 @ 04:14 PDT | Database | Reply | Distribution Data Function/Solution | Can you show how you currently do it?
|
4447 | 18 May 2016 @ 01:27 PDT | Database | Reply | skew factor | The table will be smaller when you drop those columns (or COMPRESS them), at least a Full Table Scan will be faster.
|
4446 | 18 May 2016 @ 06:32 PDT | Database | Reply | Column value is refered as Column_Name in another table | There's no reason to avoid it, you'll get best performance with a huge CASE, this is a one-time effort, you can create most of it using a Select on dbc.ColumnsV like this:
SELECT 'WH... |
4445 | 18 May 2016 @ 05:44 PDT | Database | Reply | Column value is refered as Column_Name in another table | Strange data model.
This is a simple CASE:
SELECT
CASE
WHEN A.XYZ = 'C1' THEN B.C1
WHEN A.XYZ = 'C2' THEN B.C2
END
|
4444 | 18 May 2016 @ 02:02 PDT | Database | Reply | Who dropped the table in teradata? | I really don't know why, but dbc.EventsV usually has an entry 'Logging Online Archive Off' when a table is dropped and the submitting User is also included :-)
|
4443 | 18 May 2016 @ 02:00 PDT | Database | Reply | how to determine concurrent Instances/connection | A session (LOGON ...) is a connection.
Within an application you can open multiple sessions.
|
4442 | 18 May 2016 @ 01:56 PDT | Database | Reply | skew factor | The table will only be skewed if the Primary Index is based on those columns.
Of course it's strange when there's only a single value in a column, what's the business meaning?
If you ... |
4441 | 17 May 2016 @ 07:44 PDT | Database | Reply | how to determine concurrent Instances/connection | What do you mean by connections and instances?
By default there are 2 Parsing Engines per node, each supports up to 120 sessions, so usually it's 240 sessions * number of nodes.
|
4440 | 17 May 2016 @ 07:42 PDT | Database | Reply | temporary table question | At least you got 23 more hours to read the manuals :)
does not work is not a very precise error description, you probably didn't specify the COMMIT option correctly.
A direct translat... |
4439 | 14 May 2016 @ 05:43 PDT | Database | Reply | Need to exclude data in a specific month | When you have a close look at the data you should notice that it's not '2005 8', but ' 2016 5'. Instead of casting two tim... |
4438 | 14 May 2016 @ 05:32 PDT | General | Reply | MLOAD DELETE TASK | Hi Anil,
no, if col2 is part of the PI there's no way to match NULLs using MLoad.
|
4437 | 14 May 2016 @ 05:32 PDT | Database | Reply | How to Update a timestamp field in a table in Teradata to convert from GMT o CST including daylight saving | Try if this works:
UPDATE_TS + (EXTRACT(TIMEZONE_HOUR FROM UPDATE_TS AT 'America Central')
* INTERVAL '1' HOUR)
Of course you will encounter problems with... |
4436 | 12 May 2016 @ 10:22 PDT | Database | Reply | Replace the characters with a numeric values | Hi Narasimha,
oTranslate tarnslates individual characters, not ranges.
This removes all non-digits:
regexp_replace('surya hjaukki 43516', '[^0-9]', '');
... |
4435 | 09 May 2016 @ 12:33 PDT | Database | Reply | Need help finding correct start dates | In TD14.10 you can also use FIRST/LAST_VALUE:
SEL ...
LAST_VALUE(NULLIF(ACCT_2, 0) IGNORE NULLS)
OVER (PARTITION BY ACCT_1
ORDER BY START_DATE DESC
ROWS UNBOUNDED PR... |
4434 | 07 May 2016 @ 05:06 PDT | General | Reply | convert 13 digit epoch time to date? | The TO_TIMESTAMP issue is related to Daylight Saving time zones, but is either fixed in later releases or is based on your system settings (There are several dbscontrol settings which influenc... |
4433 | 05 May 2016 @ 11:42 PDT | Database | Reply | Query :: Find tables which are accessed by users | Check if the DBQLObjTbl contains data.
|
4432 | 05 May 2016 @ 11:39 PDT | Teradata Applications | Reply | BTEQ - DELIMITER | EXPORT REPORT was meant to be used for printinh, thus it removes all non-printable characters.
Use TPT with FORMAT = 'DELIMITED' instead.
|
4431 | 05 May 2016 @ 11:36 PDT | Database | Reply | Bad data in table , need suggestion to isolate the problem | You should contact Teradata support immediately and tell them the long story :-)
|
4430 | 05 May 2016 @ 12:55 PDT | Database | Reply | Bad character in format or data | You could use a REGEXP_SIMILAR, but the easiest way is TO_NUMBER(column_abc), which simply returns NULL if it can't be converted to a numeric value.
|
4429 | 04 May 2016 @ 01:57 PDT | Database | Reply | Secondary Index Concept | 1) There's only one PI per table, but sometimes you want/need to index more than one column :)
2) All AMPs + FTS
|