#DateForumTypeThreadPost
2304 Mar 2016 @ 07:27 PSTDatabaseReplyHow do i write qualify rank() over (partition.....questionhow to get dense rank in teradata? is there any dense_rank() function available in teradata
2204 Mar 2016 @ 02:36 PSTToolsReplyCasting Zoned decimal into readable decimal sel cast(field as format '99'') output should be 12                            10 error--combination...
2128 Apr 2015 @ 08:12 PDTGeneralReplyTimestamp with time zoneHi  how to convert one time zone to another tome zone with day light saving in TERADATA. ex-from CET TO PST   Thanks in Adv  
2019 Jan 2015 @ 09:04 PSTToolsReplyFast Export issue (Kindly Help)Hi Team, need help regarding teradata fast export. i am getting restart in progress please see bold letter in log file.   0003 .LOGTABLE ERROR_T.test; 0004 .DATEFORM ANSIDATE; **** 11:3...
1919 Jan 2015 @ 08:52 PSTTeradata ApplicationsReplyFastLoad process hang with concurrent sessions Hi    i am using fast export.when i running in dev server its running fine but when i am running in SIT server the informatica session is in only running condition.   i saw the l...
1807 Nov 2014 @ 07:09 PSTTeradata StudioReplyTrying to import text file into volatile table using Teradata SQL Assistant Hi All, I have the following issue.   insert into table.namevalues(?, ?, ?, ?)   my 4th column is timstamp(6) in TERADATA   1st i export that record fr...
1714 Oct 2014 @ 09:54 PDTTeradata ApplicationsReplyFastLoad process hang with concurrent sessions hi  can any one tell me is it compolsoury that datatype of source file in informatica should be match with datatype of table in teradata   if i use fastload. i am loading file to terad...
1604 Oct 2014 @ 10:37 PDTDatabaseReplyMulti-Value compression has increased the table sizehi   what is the max number of value per column that can be compressed using MVC in TD14.  
1526 Sep 2014 @ 08:57 PDTDatabaseReplyRemove characters after '-' in a stringHi All,   I have the following date format in my source 2014-09-21 00:00:00.7563362. my datatype  in teradata is  timestamp(6). i need o/p like  2014-09-21 00:...
1415 Sep 2014 @ 09:58 PDTDatabaseTopicHOW TO GET TIMESTAMP VALUE source date format 8/18/2014 3:55:45 PM   I am given as Timestamp(0) in TERADATA  e.g – DOJ Timestamp(0) it is not working   I LOADING A FILE &nb...
1317 Aug 2014 @ 09:53 PDTTrainingReplyTeradata 14 basics certification informationHi rakesh,   I am also planning to do TD-14 basic certification. whatever  you mention is right syllabus for TD-14 basic.   could you please send me the link where i get the syll...
1214 Aug 2014 @ 08:17 PDTTrainingReplyNeed help to find out Teradata certification material Hi ,   I am planning to do the Teradata certification .   Could you please send material for TEO 141-basic certification on email id -rajinformatica2014@gmail.com &...
1113 May 2014 @ 06:35 PDTGeneralReply default character set in teradatahi colname VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL   i want to make this col as nullable how to do this .can any one post the query.
1002 May 2014 @ 09:43 PDTData ModelingReplyUsing a PPI column in PIhi i have  PI as colA and now the skew is 80%. i added one more col to that pi i.e my proposed pi is (colA,colB) AND the skew is 7%. is there any impact on downstream. like my table is  ...
918 Apr 2014 @ 08:36 PDTDatabaseReplySkew Factorthanks for reply it is a stage table . is there any specific cases where we can't use timestamp as PI  
818 Apr 2014 @ 09:56 PDTDatabaseReplySkew Factorhi can we take timestamp column as PI. HERE is my table structure can you guide me col should/shouldn't be take as PI. SVC_DSPCH_ID VARCHAR(50) CHARACTER SET UNICODE NOT CASESPECIFIC, ...
717 Apr 2014 @ 06:25 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?thanks for ur response
617 Apr 2014 @ 06:24 PDTGeneralReplyNo Spool space errorhi it is incremental table
516 Apr 2014 @ 08:28 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?hi can you tell about the use of collect stats  in  after choosing new pi //taj
416 Apr 2014 @ 08:26 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?thanks krish  for quick response it is very helpfull for me .
316 Apr 2014 @ 08:19 PDTGeneralReplyNo Spool space errorhi i new to teradata, now i am working on to reduce skew. here is my details   initially my table has 2 PI having skew 60 now i create a table on tmp database with 3 PI which has skew 3.5 ...
216 Apr 2014 @ 10:44 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?hi  can we take a column which is declare as compress(0) as PI  column. max how many column we can go for combination  to find better pi for skew
115 Apr 2014 @ 08:44 PDTDatabaseReplySkew Factorhi i am new to teradata,  HOW REDUCE SKEW FACTOR IF IT IS >60 . IN TABLE I HAVE NUPI, SHALL I GO FOR COMBINATION OF COLUMN AS PI TO CHECK SKEW FACTOR . WHAT ARE OTHER APPROACH TO REDUCE SK...