#DateForumTypeThreadPost
1120 May 2016 @ 04:19 PDTToolsTopicNeed help in using SQL AssistantHi All,   Two questions- 1. Our team is connecting to DB using SQL assistant. We connect to both dev and prod. Recently one of our team member by mistake connected to prod and deleted data ...
1018 Aug 2015 @ 10:49 PDTDatabaseTopicNeed help on deleting duplicate records of a intraday runHi All, I have SET table, which is of only insert type (daily feed). It's a stage table and loading from a flatfile. Now, I have make it as a intraday run and  need to pick only the data ...
906 Jul 2015 @ 04:55 PDTDatabaseReplyCreate tables for loading changing filesHi Dieter,   Regarding the requirement which I posted earlier, I got some more additional clarification from business-   All the columns will be of VARCHAR (50) type. It is going...
802 Jul 2015 @ 11:18 PDTDatabaseReplyHow to bring un-utilized space for utilization in terdataHi Fred,   Thanks for posts. They are really useful. One final question here-   what is the solution for improving skewness for a existing table with data? 1.If a create a new table ...
702 Jul 2015 @ 05:21 PDTDatabaseReplyHow to bring un-utilized space for utilization in terdataFred,   3rd question   1. I have calculated SUM(CurrentPerm)/1024/1024/1024 & MAX(CurrentPerm) * (HASHAMP()+1)   for a particular database in DBC.DISKSPACE. The outpu...
602 Jul 2015 @ 04:21 PDTDatabaseReplyHow to bring un-utilized space for utilization in terdataHi Fred,   Thanks for your inputs. That helped alot. can you please update me below points too:   1. In what scenarios defining a table as SET is better than defining it as a MULTISET...
529 Jun 2015 @ 04:25 PDTDatabaseTopicHow to bring un-utilized space for utilization in terdataHi, I am going through some of the topics on space utilization and got confused. Can you please clarify the below points: 1. I have calculated SUM(CurrentPerm)/1024/1024/1024 & MAX(Current...
425 Jun 2015 @ 11:21 PDTDatabaseReplyCreate tables for loading changing filesHi Dieter, Yes, I too asked business the same question about what they are going to do after loading.. :-) They are yet to come back. In the meanwhile can you please let me know few poi...
320 Jun 2015 @ 10:36 PDTDatabaseTopicCreate tables for loading changing filesHi Everyone,   I have a requirement as below:   I will be receiving a flat file which can come with 10 fields at one time and for next instance it can come with 12 fields,later with 1...
203 Mar 2015 @ 09:38 PSTTeradata ApplicationsTopicNeed to load data from a flat file to teradata tableHi,   I need to prepare .sh script to load data from a flat file to teradata tables. Below are the flexibilities to be handled:   1. The file name should popaulate as the value for th...
124 Nov 2014 @ 03:34 PSTDatabaseTopicNeed help on creating table. Error 3933Hi All,   I am trying to create a table with app. 400 columns, out of which most of them are 'Varchar'. But I am getting an error as-3933 'Max row length exceeded'. I kept th...