#DateForumTypeThreadPost
2420 Aug 2015 @ 11:27 PDTPrivate Forum
2320 Aug 2015 @ 08:03 PDTDatabaseTopicUnpack column valuesHello, any one has solution for this? is there unpack udf with anyone and willing to share? Problem:- Column values:  abcd, 1234, 3456, 34656,......, nnnn Desired Output: col1 &nb...
2220 Aug 2015 @ 08:02 PDTPrivate Forum
2107 Apr 2014 @ 12:48 PDTDatabaseReplyQuery band in procedure. SET QUERY_BAND ';' UPDATE FOR SESSION;"Hello Pauldancer, are you willing to share your custom proc with us?  I have a need for this now and I got two options in front me.  One is what you have already implemented and other is ...
2010 Mar 2014 @ 02:07 PDTDatabaseReplyfinding links between two col values..Thanks Dieter.  Looks like it is grouping them correctly, I will have to test it out with our data.   Thanks for giving the directions If rows or its size would be a problem, I can try it...
1908 Mar 2014 @ 11:31 PSTDatabaseReplyfinding links between two col values..Dieter, may be I did not understand when you said circular reference and may be it found me :-((   here is real dataset..  we got case 1) a= b and b = a and then  case 2) we got a =...
1807 Mar 2014 @ 09:11 PSTDatabaseReplyfinding links between two col values..thank you Dieter. grouping them is key for me and you made it look so simple. I am eliminating circular references, I do not need them. This is one of the many knots I got to resolve.. thanks agai...
1707 Mar 2014 @ 11:46 PSTDatabaseReplyfinding links between two col values..Santanu84: thought about it but dont know where I am going with it..  If someone can play with this code and try it out that would be very helpful...   CREATE VOLATILE TABLE val (co...
1606 Mar 2014 @ 09:33 PSTDatabaseTopicfinding links between two col values.. from below data set   Cola Colb 1 20 20 31 31 40 40 5   10 11 10 120 120 13   100 201 201 210 201 103   1000 4...
1524 Oct 2013 @ 09:18 PDTViewpointTopicTASM Portlets are temporarily Unavailable, how to get them back online?When trying to access workload designer or monitor I am getting below messages, how to get these back online.  I have enabled a throttle yesterday and I want to disable it now, it is causing T...
1430 Apr 2013 @ 06:54 PDTDatabaseReplyEstimate and Actual are different and causing PJ.So just you all know we were able to address this.  One of our DBA had identified bad stats (Parition + highly non unique column) were causing the plan to wayward!!   Thanks  Bhan...
1329 Apr 2013 @ 07:41 PDTDatabaseReplyEstimate and Actual are different and causing PJ.@Dieter:  Yes it is same as SPOLISETTI question.  When we first got this problem we suggested the same to the users but they are so tough on not changing their query.  They are...
1227 Apr 2013 @ 07:03 PDTDatabaseReplyETL managment  Teradata offers different tools to load and unload data from Teradata DBMS.  Type this "teradata load and unload utilities" in google and go through the results for more k...
1127 Apr 2013 @ 06:29 PDTDatabaseTopicEstimate and Actual are different and causing PJ.  Hello All;  I am looking for your valuable suggestions on this. Query which used to work with out any issues is now giving hard time.  Same query runs fine (<3 min) on prod ...
1015 Feb 2012 @ 02:30 PSTThird Party SoftwareTopicSQL Server Replication and Teradata   We are planning to replicate data from MS SQL Server databases to Teradata RDBMS using SQL Server Replication, and we would like to know whether it is possible or not? if it is possib...
915 Feb 2012 @ 02:29 PSTToolsTopicSQL Server Replication and Teradata We are planning to replicate data from MS SQL Server databases to Teradata RDBMS using SQL Server Replication, and we would like to know whether it is possible or not? if it is possible then wha...
807 Feb 2012 @ 09:42 PSTPrivate Forum
703 Feb 2012 @ 06:03 PSTPrivate Forum
614 Nov 2011 @ 12:47 PSTPrivate Forum
521 Oct 2010 @ 04:19 PDTDatabaseReplyHow to find a particular table in Teradata is locked using SQL query?Locking Logger is a good tool to use. it captures all the blocks and locks.
421 Oct 2010 @ 04:16 PDTDatabaseReplyBackup All database objects only without data....run this in arcmain... .logon ******; archive dictionary tables (dbc) ALL, release lock, output row count, file = filename; logoff;
321 Oct 2010 @ 08:49 PDTUDAReplyTERA DATA WARE HOUSE MODELAnswers 1) How can I replace the existing system and built a data ware house in TERA DATA . You need to model existing star schema design in TD and before you do it you may have to develop stage ...
215 Jul 2010 @ 05:34 PDTDatabaseTopicdyn sql in stored procedure SET dyn_sql = 'Select TableName into hTableName from ' || TRIM(i_FullWorkTableName) || ';' ; call dbc. SysExecSQL(:dyn_sql) ; SET dyn_sql = 'call sysdba.spETL_Table_' || hTableName|| '(:...
115 Apr 2010 @ 09:39 PDTDatabaseReplyQCD (Query Capture Database) in Visual explain Plan...This is from DB admin doc... Use the INSERT EXPLAIN statement to capture the query plan into the QCD database. Note: You can alternatively store the query plan as XML into the QCD.XMLQCD tabl...