#DateForumTypeThreadPost
1811 Feb 2016 @ 11:22 PSTDatabaseTopicOptimal Process to load data from SQLserver to TeradataWe have a a number of processes where in we transfer the data from SQL server to TD. We extract he data as files & then dump it using Fastload. Just wanted to know is there any other process we...
1720 Jul 2014 @ 10:59 PDTDatabaseReplyImpact of using a compressed column in any join or predicate clause in a queryThanks all for clearing the doubt, henceforth i will keep that in mind :)
1618 Jul 2014 @ 07:29 PDTDatabaseTopicImpact of using a compressed column in any join or predicate clause in a queryHi All, I would like to know If there would be any impact of I/O if we perform any join operations or filter operations on the compressed column considering compression property is majorly a space...
1512 Jun 2014 @ 06:09 PDTDatabaseReplyOrder Of columns in PI for multilevel Partitioned TableHi, Sorry for a late reply. I do think the same ways. Thanks for conforming :)
1404 Jun 2014 @ 08:24 PDTDatabaseTopicOrder Of columns in PI for multilevel Partitioned TableHi All, I am aware that order of columns in defined PI doesn't matter. But if we have multilevel Partition defined on the table and we are including the partitioning columns as a part of PI, ...
1310 Feb 2014 @ 02:22 PSTDatabaseReplyGenerating Surrogate Key Using ROWNUMAdeel, Its loaded from a single source(TD source table). I tried with "SUM(1) OVER(ROWS UNBOUNDED PRECEDING).." method as mentioned above, but did not find much difference.
1203 Feb 2014 @ 01:08 PSTDatabaseReplyGenerating Surrogate Key Using ROWNUMAdeel, Estimated Row count = 200 million Dieter, I guess its the calculation of the ROW_NUMBER() part because I tried without the max part but of no help. The query is something like this:...
1131 Jan 2014 @ 04:59 PSTDatabaseTopicGenerating Surrogate Key Using ROWNUMHi All, Greetings ! I have a requirement where I have to generate a surrogate ID for every row in the FACT table. Previously we used to use ROW_NUMBER() for the same. But the data volume has gone...
1024 Mar 2013 @ 08:52 PDTToolsTopicRestarting Fastload if we have error with the source data fileHi, I had encountered today a failure with fastload. There was some issue with the source file for which the fastload got paused. I corrected the data and restarted the run, but it didnt succeed. ...
927 Aug 2012 @ 08:04 PDTDatabaseTopicNeed help understanding MLPPI ? Hi All, I am facing trouble understanding the terms contigous partition and repositioning when i am reading material related to MLPPI. Could anyone please do me a favour understanding these...
813 Aug 2012 @ 08:24 PDTDatabaseReplyMax value for datatype column. Thanks a ton, the suggest approach got me my result !!
713 Aug 2012 @ 06:18 PDTDatabaseTopicMax value for datatype column. Can we write a SQl to determine the max value of a datatype ? For ex: if we have a column emp_id as INTEGER, the SQL would have emp_id as input and the result would be the max value for inte...
625 Mar 2012 @ 01:36 PDTDatabaseReplyPerformance question You should try using the implicit datatype conversion where ever possible, if not possile you should make use of cast function.
521 Jan 2012 @ 12:42 PSTDatabaseReplyDDL review I am supposing your table is a final table. Looking at the datamodel can give you a better idea of the indexes u need to create for the table.The creation of partition column always is not n...
415 Jan 2012 @ 02:31 PSTDatabaseReplyQuerry error...... You can debug it from the SQL Assistant as it specifies the error and line number. Yes..there are specific error numbers for a defined errors..you can find a teradata error document where yo...
306 Dec 2011 @ 06:16 PSTDatabaseTopicAltering SET to MULTISET Hi, Is there is a way to alter a set table to multiset apart from drop re-create table..?
207 Sep 2011 @ 01:52 PDTDatabaseReplyTimestamp Datatype Thanks for helping out.
106 Sep 2011 @ 05:22 PDTDatabaseTopicTimestamp Datatype Hi All, Can you please explain the concept for timestamp(0),timestamp(1) ....timestamp(6)..? Thanks in advance for the help.