18 | 31 Oct 2015 @ 06:47 PDT | Database | Topic | Secondary Index and Joins | Hi,
Can anyone please explain if Secondary Indices provide any help in performance when the SI columns are used in a Join condition ? I believe they only help the performance when used in residual... |
17 | 28 Oct 2015 @ 12:22 PDT | Database | Topic | SET vs MULTISET Table with UPI/USI |
I understand that a SET table has an overhead of checking for duplicate rows while data is being inserted into the table. However, if the table has a UPI/USI defined on it, only the UPI/USI colu... |
16 | 07 Oct 2015 @ 10:34 PDT | General | Reply | Dropping PI from a table | If I drop PI from an empty table then does it automatically become a NoPI table ? I mean is that possible even without having to specify the "No Primary Index" clause ?
Thanks.
|
15 | 03 Oct 2015 @ 11:26 PDT | General | Topic | Dropping PI from a table | Hi,
Is it possible to drop PI from an empty table in Teradata. Then load data into it and then recreate the PI to make the data load faster ?
Please advise.
Thanks,
Raj
|
14 | 25 Aug 2015 @ 10:37 PDT | Database | Topic | DB2 Packed Decimal | Hi,
I am working on migration from DB2 to Teradata. I found out that all Decimal fields in DB2 are defined as Packed Decimals that includes a sign (negative or positive). What would be the... |
13 | 27 Jul 2015 @ 10:21 PDT | Database | Topic | DB2 to Teradata Migration | Hi,
I am presently working on DB2 to Teradata migration. I am trying to convert one DB2 data-type to its Teradata equivalent. Can anyone please help me figure out what will be the Teradata equival... |
12 | 27 Jul 2015 @ 10:15 PDT | Database | Reply | Usage of Staging tables with NoPI and Insert/Select | Hi,
Thanks for pointing me to the post. It was really helpful. However, here is a question pertaining to a statement in the post -
"....its rows can be dispatched to any given AMP... |
11 | 15 Jul 2015 @ 04:51 PDT | Database | Topic | Usage of Staging tables with NoPI and Insert/Select | Hi,
It is often recommended to first load the data to a Staging table with NoPI and then use Insert/Select to load the data from the Staging table to the base/production tables vs loading the data... |
10 | 13 Jul 2015 @ 12:44 PDT | Database | Topic | PPI table and concurrent load to same table | Hi,
For a PPI table (with a NUPI), is it possible to load data concurrently to the same table via multiple sessions by the same user ? In other words, in a PPI table does TD lock only a pa... |
9 | 15 Apr 2015 @ 10:17 PDT | Database | Topic | ODBC vs Bteq for Insert/Select | Hi,
We are using Informatica PC to move data from TD Staging tables to TD Target tables leveraging Push Down Optimization via ODBC connection. Essentially, this is converted to INSERT/SELECT and U... |
8 | 06 Apr 2015 @ 05:25 PDT | Database | Reply | Loading to the same target table simultaneously | So are we saying that if its a PI "value" based update then it will be a row-level lock. Otherwise if the update is performed on the target table even by joining to a Staging table by app... |
7 | 06 Apr 2015 @ 06:33 PDT | Database | Reply | Loading to the same target table simultaneously | Thanks for you reply dnoeth. So isnt there any way by which a table could be updated/inserted concurrently by multiple sessions in TD15 ?
So if I understand correctly for TD15, concurrent updates ... |
6 | 05 Apr 2015 @ 09:12 PDT | Database | Topic | Deadlock on DBC.USERRIGHTS | We are using Informatica PDO to load TD tables and while running multiple sessions concurrently, we encountered an issue wherein the processes were failing due to a deadlock on dbc.userrights table... |
5 | 04 Apr 2015 @ 08:56 PDT | General | Topic | Using Ansi MERGE | Hi,
Can MERGE be used to insert/update into the same target table simultaneously by different sessions (reading different source tables) without locking the target table ?
Thanks
|
4 | 03 Apr 2015 @ 03:00 PDT | Database | Topic | Loading to the same target table simultaneously | Hi All,
I am new to Teradata. I am facing an issue while trying to load to the same TD target table from multiple staging tables simultaneously. I searched the net but got confusing inputs. Please... |
3 | 13 Mar 2015 @ 01:30 PDT | General | Topic | Stored Proc to Find and Drop tables (Dynamic SQL) | Hi Folks,
I want to create a Stored Proc wherein I will first find a list of tables to be dropped as :
select tablename from dbc.tables where tablename like '%Test%' and ... |
2 | 13 Mar 2015 @ 12:49 PDT | Database | Topic | Stored Proc to drop Select Tables using Cursor | Hi Folks,
I want to create a Stored Proc wherein I will first find a list of tables to be dropped as :
select tablename from dbc.tables where tablename like '%Test%' and Tablekind ... |
1 | 30 Jul 2011 @ 02:40 PDT | Database | Topic | Access details about a table / column | Hi Folks,
How can I find out when a table/column was accessed and why whom in teradata ? Access would mean any DML/DDL statements using the column.
Any help is appreciated.
Thanks
|