#DateForumTypeThreadPost
1405 Jul 2016 @ 02:35 PDTDatabaseTopicTPTI am trying to load a table in teradata using informatica with teradata parallel transported connection with an update operator. I want to see how the data in INFA_ET1 and INFA_ET2 looks like. So ...
1308 Dec 2015 @ 09:27 PSTDatabaseReplyStored Procedure ErrorPriya, THis is resolved now.  As suggested by other teradata forums, i created the volatile table V_TABLE1 outside of SP in the same session and then compile the above SP. Now the SP co...
1208 Dec 2015 @ 08:52 PSTDatabaseReplyStored Procedure ErrorPriya,   These are errors and not warnings. V_TABLE2 is a permanent table created outside of the stored procedure
1108 Dec 2015 @ 03:28 PSTDatabaseTopicStored Procedure Error I am getting the below error when i  execute the below script   CREATE PROCEDURE DB_T_STAG_R1_DEV.SP_SAMPLE_SH (OUT STATUS INTEGER) BEGIN CREATE VOLATILE TABLE V_TABLE1...
1020 Nov 2015 @ 02:44 PSTDatabaseReplyFind the first occurance of Number in a stringif the first character is C followed by a number, for example C23, the hexa decimal value of C is 43 and you will end up getting wrong results if you use the above logic
903 Nov 2015 @ 02:56 PSTToolsTopicBTEQ TPTI want to understand the difference in the usage of a TPT script vs BTEQ script.    Say I am writing a complex SQL with joins on 15 tables, (each table approximately having 1 million ro...
801 Aug 2015 @ 08:46 PDTDatabaseTopicViews and LocksCan some tell me if my understanding on the views and locks are correct based on the below example.   I have created a view as below --View Definition Type 1 (Implicit Read Lock) CREATE VI...
712 Jun 2015 @ 11:33 PDTDatabaseTopicCast CHARSEL CAST('A'AS CHAR(10)); SEL CASE WHEN 1=1 THEN CAST('A' AS CHAR(10)) ELSE 'Y' END;   The first query gives 'A' followed by 9 spaces. The Second query gi...
630 Oct 2014 @ 07:27 PDTToolsReplyMload Performance IssueYes I Spoke with my DBA and he said that he has changed nothing on the settings. I think my DBA would have installed the MLOAD utility in informatica server and i want to see the settings of the M...
529 Oct 2014 @ 02:22 PDTToolsReplyMload Performance IssueI have an Informatica mapping trying to load data from a flatfile to a table. The target table uses MLOAD to load the table in one of the database in teradata development database. Till yesterday...
429 Oct 2014 @ 02:21 PDTToolsTopicMload Performance IssueI have an Informatica mapping trying to load data from a flatfile to a table. The target table uses MLOAD to load the table in one of the database in teradata development database. Till ...
327 Dec 2013 @ 02:03 PSTDatabaseReplyTable PartitionHi Khurram, Thank you very much for quick response and also the link. I have one more question. The below query gives  the result as shown sel tablename,definedcombinedpartitions,m...
227 Dec 2013 @ 09:11 PSTDatabaseReplyTable PartitionHi, -- CASE 1 CREATE SET TABLE INFORM_USER.TABLEA ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( PLCY_NBR INTEGER, MO_ID INTEGER, PLCY_S...
126 Dec 2013 @ 11:26 PSTDatabaseTopicTable PartitionCREATE SET TABLE INFORM_USER.TABLEA ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( PLCY_NBR INTEGER, MO_ID INTEGER, PLCY_STATUS VARCHAR(20...