#DateForumTypeThreadPost
3921 Dec 2007 @ 12:06 PSTUDAReplyTuning Teradata SQLHi ,Please refer Teradata manuals (Data Definition Statements,Data Manipulation Statements, SQL fundamentals,Database Design) and learn about various methods of tunig the SQL in teradata.If you are...
3821 Dec 2007 @ 04:54 PSTDatabaseReplyTo Copy into identity columnsHi,Define your identity column as 'GENERATED BY DEFAULT AS IDENTITY'.Rgds,Aravind Hegde
3722 May 2007 @ 10:57 PDTUDAReplyHow do write Insert ststement with where condition in MloadHi,You have to specify the where clause along with the apply statement in the mload script.like this,apply ins_rec where col1=1234;here ins_rec is the labe for the DML and col1 is the column from t...
3617 May 2007 @ 10:11 PDTAnalyticsReplyPARTY DEMOGRAPHIC HIST in CLDMHi,Sorry, I don't know the reason for it.Rgds,Aravind
3516 May 2007 @ 12:07 PDTAnalyticsReplyPARTY DEMOGRAPHIC HIST in CLDMHi,The Party Demographic Hist entity allows storage of specific values in the Party_Demog_Val Field.For example:The Demographic Item of the Party is Income. The Income range is $40000 to $60000 and...
3425 Apr 2007 @ 09:19 PDTDatabaseReplyRequired helpHi,I don't think you can get this query to be finished in less than 30 minutes.Explain Plan itself telling the time of 1hr 3 min for sum step.We also have this kind of scenario in our project,so we...
3325 Apr 2007 @ 07:30 PDTDatabaseReplyRequired helpHi Sushant,The all amp stat functions MIN() over (Partition by) and Max() over (Partition by) on billions of rows is the reason for this query to run for long time.Avoid this function.Simple Min an...
3211 Apr 2007 @ 11:20 PDTDatabaseReplyGenerating Unique IDs(Numbers) based on Unique KeysHi,when you are talking about millions of records,is it for entire table or in each batch?If 1 or 2 million records come from the source in each batch,the CSUM or RANKfunctions will not take time t...
3102 Feb 2007 @ 10:09 PSTUDAReplyNeed A Career Switch to Data WireHousingHi,I feel that good way is to use your mainframe knowledge in working in Data warhousing projects whcih migrate data from mainframes or use mainframes as a Source.You can work initially in the migr...
3019 Jan 2007 @ 08:31 PSTDatabaseReplyValue compression on timestamp columnHi,Its difficult for me to give a use case for this.But in our data warehousing environment,we keep track of the load time of target tables as a timestamp column.I wanted to compress the timestamp ...
2911 Jan 2007 @ 08:11 PSTDatabaseReplyValue compression on timestamp columnHi,I'v done null compression for timestamp. If multivalue compression is also possible, please let me know.--thanks,Aravind
2802 Jan 2007 @ 09:32 PSTDatabaseReplyValue compression on timestamp columnHi,Sachin,Documentation says that Timestamp column can't be compressed.But,I'v seen that null value compression is possible for timestamp column.--Rgds,Aravind
2730 Dec 2006 @ 04:45 PSTDatabaseReplyValue compression on timestamp columnHi Sachin Thanks for the reply.One thing I'v noticed is I can compress null values for timestamp column.But Multi Value compression on timestamp column is what I wanted.If you get this one also,pl...
2628 Dec 2006 @ 03:48 PSTDatabaseTopicValue compression on timestamp columnHi all,I want to know how to compress a column with timestamp(6) datatype.Can anybody give the syntax for the same.Thanks and Regards,Aravind
2519 Dec 2006 @ 04:38 PSTDatabaseReplyTransfer a table to a different databaseHi,You can use copy objects option from the file menu(F8 command) from the Teradata Administrator(winddi) to accomplish this task.--Regards,Aravind
2419 Dec 2006 @ 04:33 PSTDatabaseReplyaltering column attributesHi,You can use the ALTER TABLE statemant to do this.For example:Alter Table table1 add col1 dec(12,2);Note that you cannot alter the column if it is a primary index column.---Aravind
2319 Dec 2006 @ 12:47 PSTToolsReply911-ETL developerHi,I believe that u can get a job as a ETL developer without experience also,since you are currently a business analyst.Your knowledge and experience as a business analyst helps in technical role.H...
2218 Dec 2006 @ 08:16 PSTToolsReply911-ETL developerHi,First of all,I am not a teradata expert,but have some experience as ETL developer in teradata.So,I want to share bit of my experience which may help you.1)You must know SQL to an intermediate l...
2118 Dec 2006 @ 08:05 PSTDatabaseReplyLength of IntegerHi,First You need to cast your integer column to varchar and then use charactersor character_length function to find out the length of the column.For ex:SELECT CHARACTER_LENGTH(CAST(COL1 AS VARCHAR...
2014 Dec 2006 @ 04:29 PSTDatabaseReplySQL optimization helpHi,gogul, thanks for ur reply.But I want to know,how partitioning helps for queries which try fetch data between two dates?--Aravind
1913 Dec 2006 @ 10:27 PSTDatabaseTopicSQL optimization helpHi all,I have to optimize some queries.In a typical reporting scenarion in BO,the user will enter the dates thru calendar and these dates coming as the column cdate from sys_calendar.caldates are ...
1813 Dec 2006 @ 10:24 PSTDatabaseTopicSQL optimization helpHi all,I have to optimize some queries.In a typical reporting scenarion in BO,the user will enter the dates thru calendar and these dates coming as the column cdate from sys_calendar.caldates are ...
1716 Nov 2006 @ 12:00 PSTToolsTopicSpace required for a Multiload JobHi all,I have to load a flat file of size 106 GB through mload.I have 390GB space left in the database.However I'm not able load this file because of space .I get the error as 'No more room in the ...
1614 Nov 2006 @ 09:21 PSTDatabaseReplyPPI - Global Temporary TableHi Manu,I am using Teradata V2R6( version 06.01.01.11).If you are in any Teradata customer site,I suggest you to contact Teradata global consulting centre.
1514 Nov 2006 @ 05:13 PSTDatabaseReplyPPI - Global Temporary Tablehi,I work with Teradata V2R6 and it is possible to have PPI for Global TemporaryTables.Rgds,Aravind

Pages