#DateForumTypeThreadPost
1817 Feb 2015 @ 03:35 PSTDatabaseReplySpool SpaceThanks Dieter,Now i am clear.
1717 Feb 2015 @ 11:43 PSTDatabaseReplySpool SpaceThanks,so dropping unwanted permanent tables will give more spool space right ?
1613 Feb 2015 @ 01:33 PSTDatabaseTopicSpool SpaceHi,      I read "unused Perm space is spool space" in one document. My question was when we get "No spool space" error while processing the query ,if we d...
1523 Oct 2014 @ 06:12 PDTDatabaseTopicLoad Different DATE formats into TeradataHi,     I have a requirement to load different date formats into teradata(Format MM-DD-YYYY HH:MM:SS) ,what is the transformation logic to handle different type of formats
1418 Oct 2014 @ 12:15 PDTDatabaseReplyDML through multi table viewThank you Dieter
1317 Oct 2014 @ 07:17 PDTDatabaseTopicDML through multi table viewHi,     I was trying to insert record into one of the base table through multi table view,it is giving error saying "View may not be used for insert/update/delete".but same ins...
1218 Sep 2014 @ 09:39 PDTDatabaseReplyDynamic partition eliminationThanks for the info,still i am not clear can you give one example.When DPE will occur and when static partition elimination will occur. Thanks in advance
1118 Sep 2014 @ 09:32 PDTDatabaseTopicCharacter setHi,     What is the differnce between unicode and latin character set.How can we choose the character set while creating table.Is there any way to convert unicode characters into Latin....
1018 Sep 2014 @ 09:25 PDTDatabaseTopicLocking the tableHi,     I have a requirement,i have to run multiple SQL statements but i need to make sure no one can access the table while running these sqls.How i can achieve this. Ex: BT se...
912 Sep 2014 @ 02:44 PDTDatabaseTopicCollect statsHi     I have a requirement where I have to load like below, Table A->intermediate table 1->intermediate table 2->table B running above statements between BTET.have to collec...
812 Sep 2014 @ 02:25 PDTDatabaseTopicDynamic partition eliminationHi,     I am new to teradata.what is dynamic partitioning elimination when it is comes under picture.please clarify
712 Sep 2014 @ 02:25 PDTDatabaseTopicDynamic partition eliminationHi,     I am new to teradata.what is dynamic partitioning elimination when it is comes under picture.please clarify
621 May 2014 @ 08:43 PDTGeneralTopicSpace AllocationHi,    Can any one explain how space will be allocated for PERM,SPOOL,TEMP space with example in teradata.    Thanks, Sravanthi
521 May 2014 @ 08:38 PDTGeneralReplyNumber of bytes-BIGINTThanks for the clarification.
415 May 2014 @ 09:29 PDTGeneralTopicNumber of bytes-BIGINTHi   I have doubt in allocation of bytes , For example there is one BIGINT column having 2 values 1,10000.My doubt is for both the values terdata assign 8 bytes(as BIGINT occupies 8 bytes) o...
312 May 2014 @ 08:19 PDTGeneralReplyConvertion from SQL Server to TeradataUsed convert(varchar(30),cast([column_name] as varbinary(30)),1) Getting correct value in teradata. Thanks for the help.
217 Apr 2014 @ 09:22 PDTGeneralTopicConvertion from SQL Server to TeradataHi,    We are loading data from SQL server to Teradata using informatica.our issue is,there is one timestamp column(contain binary data) in sql server.we need to load into...
115 Apr 2014 @ 08:06 PDTGeneralTopicWhen we need to collect stats on tableHi,      we are loading data into teradata through informatica using TPT load connection.Our load type is truncate and reload every month. 1)Do i need to collect the stats on...