#DateForumTypeThreadPost
904 Aug 2015 @ 09:51 PDTDatabaseTopicStored procedure runs in SQL assistant but given error when triggered through InformaticaHi,   I have createda simple stored procedure to truncate and load a target table and I am passing schema name as parameter. When I run the procedure in SQL assitant it executes correctly, ...
820 Nov 2014 @ 12:09 PSTDatabaseReplyDropping and creating case_n partitionoohk. Thank you dnoeth.
719 Nov 2014 @ 11:20 PSTDatabaseReplyDropping and creating case_n partitionI believe its something like ALTER TABLE DWS.SALES MODIFY DROP... But I am not getting it right. Please guide me. Thanks.
619 Nov 2014 @ 11:18 PSTDatabaseTopicDropping and creating case_n partitionHi, Please help me get the syntax for droping a creating case_n partition on a given table. The table structure for the same is given below. CREATE MULTISET TABLE DWS.SALES,NO FALLBACK , ...
521 Oct 2014 @ 04:52 PDTDatabaseReplyTeradata query tunningHi Ravi, I collected multi column stats on the tables on PI and joining columns. This is a query that is generated by BO and I cannot tweek the query. I am supposed implement the indexing or col...
420 Oct 2014 @ 11:23 PDTDatabaseTopicTeradata query tunning explain SELECT   DIM_PFC_CUSTOMER_LIST_dim.DISTR_METHOD,   DIM_PFC_CUSTOMER_LIST_dim.PFC_DESC,   DIM_PFC_CUSTOMER_LIST_dim.KEY_ACCOUNT_DESC,   DIM_PFC_CUSTOMER_LIST_dim.B...
312 Jun 2013 @ 03:29 PDTDatabaseReplySpool space issueHi Dieter, Thanks for your suggestion. Since I am a developer, I donot have access to dbc.QryLogStepsV. Anyways i tried collecting stats on underlying tables but still i get the same error....
212 Jun 2013 @ 12:08 PDTDatabaseTopicSpool space issueHi, I encountered a spool space issue while running the query. Kindly help me understand the root cause and if there are any specific areas to look for in case of spool space issue. Thanks in ad...
111 Jun 2013 @ 11:52 PDTDatabaseTopicSpool space issue