11 | 22 Jul 2014 @ 01:15 PDT | Database | Reply | Prolonged Responding State - for data load cases | Hi.. could anyone help ?
|
10 | 15 Jul 2014 @ 02:57 PDT | Analytics | Reply | For AMP Number HASHMAP()+1 | We add '1' cause the AMP numbering starts from 0 (zero), not 1 (one).
If your system has 32 Amps, the amps are numbered from 0 to 31. HashAmp() gives the max amp number and you add 1 to fi... |
9 | 15 Jul 2014 @ 01:59 PDT | Database | Reply | Position value for numeric, alphabets and blank | You can use CASE statement.
CASE
WHEN SUBSTR(ColumnName,1,1) <> 'B'
AND SUBSTR(ColumnName,2,1) BETWEEN 1 AND 9
AND SUBSTR(ColumnName,3,1) BETWEEN 1 AND 9
THEN 'AB... |
8 | 15 Jul 2014 @ 01:43 PDT | Database | Reply | All AMP active for Updates based on primary index | hi dnoeth,
I run update against view and the view is defined as locking row for access. Surprisingly, the same query in production results 1 Active Amp (as it should be), whereas in UAT its all AM... |
7 | 14 Jul 2014 @ 03:54 PDT | Database | Reply | All AMP active for Updates based on primary index | Thanks Dixxie and Todd.
I am running only single update at a time.
My table is defined as MultiSet - I don't see why the behaviour would be different.
I found out the number of Amps active f... |
6 | 11 Jul 2014 @ 09:16 PDT | Database | Reply | Blank space check based on the position | Please let us know, what exactly you want to acheive with some examples of input and desired output.
|
5 | 11 Jul 2014 @ 09:11 PDT | Database | Reply | Execute Query based on IF condition | If you are using BTEQ, use dummy query to check condition:
/
/*Below statement uses sys calendar table as dummy to check condition – if the condition is true, then the SQL ret... |
4 | 11 Jul 2014 @ 08:59 PDT | Database | Reply | All AMP active for Updates based on primary index | How can rows be on every amp ? I have the primary index in where clause. Here is the explain plan:
The explain plan shows Single Amp Update.
|
3 | 11 Jul 2014 @ 05:16 PDT | Database | Reply | XML data - Relational table data Comparison | I faced similar situation.
Either generate XML separately from tha table using your own code and compare both the XMLs OR load the XML into teradata and comapre the tables.
Do let me know, if you... |
2 | 11 Jul 2014 @ 05:10 PDT | Database | Topic | All AMP active for Updates based on primary index | Hi All,
I am updating my tables based on primary index, however from the DBQL I see all the amps are active. Could someone explain, if this is expected ?
Cannot post the table structre fo... |
1 | 11 Jul 2014 @ 04:46 PDT | Database | Topic | Prolonged Responding State - for data load cases | Hi,
I am loading data thru informatica to teradata in relational mode. i.e. the queries are are simple 'insert' and 'update' statements. All the requests are tied in BT-ET transact... |