#DateForumTypeThreadPost
1831 Oct 2015 @ 06:47 PDTDatabaseTopicSecondary Index and JoinsHi, 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...
1728 Oct 2015 @ 12:22 PDTDatabaseTopicSET 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...
1607 Oct 2015 @ 10:34 PDTGeneralReplyDropping PI from a tableIf 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.
1503 Oct 2015 @ 11:26 PDTGeneralTopicDropping PI from a tableHi, 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 
1425 Aug 2015 @ 10:37 PDTDatabaseTopicDB2 Packed DecimalHi,   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...
1327 Jul 2015 @ 10:21 PDTDatabaseTopicDB2 to Teradata MigrationHi, 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...
1227 Jul 2015 @ 10:15 PDTDatabaseReplyUsage of Staging tables with NoPI and Insert/SelectHi,   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...
1115 Jul 2015 @ 04:51 PDTDatabaseTopicUsage of Staging tables with NoPI and Insert/SelectHi, 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...
1013 Jul 2015 @ 12:44 PDTDatabaseTopicPPI table and concurrent load to same tableHi,   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...
915 Apr 2015 @ 10:17 PDTDatabaseTopicODBC vs Bteq for Insert/SelectHi, 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...
806 Apr 2015 @ 05:25 PDTDatabaseReplyLoading to the same target table simultaneouslySo 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...
706 Apr 2015 @ 06:33 PDTDatabaseReplyLoading to the same target table simultaneouslyThanks 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 ...
605 Apr 2015 @ 09:12 PDTDatabaseTopicDeadlock on DBC.USERRIGHTSWe 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...
504 Apr 2015 @ 08:56 PDTGeneralTopicUsing Ansi MERGEHi, 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
403 Apr 2015 @ 03:00 PDTDatabaseTopicLoading to the same target table simultaneouslyHi 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...
313 Mar 2015 @ 01:30 PDTGeneralTopicStored 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 ...
213 Mar 2015 @ 12:49 PDTDatabaseTopicStored Proc to drop Select Tables using CursorHi 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 ...
130 Jul 2011 @ 02:40 PDTDatabaseTopicAccess details about a table / columnHi 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