#DateForumTypeThreadPost
11209 Apr 2013 @ 10:17 PDTGeneralReplyCast from CHAR(20) to SMALLINTI just created the same scenario on my databases (13 & 14) and it worked fine w/o any error, unless '?' is actually 'question mark' and not representing the NULL value. Are you...
11109 Apr 2013 @ 05:50 PDTGeneralReplyWhere is Teradata SQL AssistantLooks like you are not able to connect to server. Check if the server is up and you have proper rights to connect to that server. Btw, are you using ODBC to connect ?
11009 Apr 2013 @ 05:47 PDTGeneralReplyBLANK FROM SOURCE IS CONVERTED TO 0 while loading into TableOf course, we can have NULL values in integer column. Check your ETL code, it must be converting NULL to 0 somewhere. Also, check the table definition and see if there is "DEFAULT 0"...
10903 Apr 2013 @ 10:10 PDTGeneralReplyCEIL and FLOOR functionsOh k. I thought teradata introduced it in TD13. When I write a SQL using these in TD13 sql assitant, it turns BLUE (like any teradata function), so I thought its already there but not working....
10803 Apr 2013 @ 07:01 PDTGeneralTopicCEIL and FLOOR functionsHi, I am trying to use CEIL and FLOOR functions of teradata in TD13 and TD14 as we have migrated to TD14 in DEV and QA but still at TD13 in PROD. Somehow, these functions work fine in TD14, but gi...
10703 Apr 2013 @ 05:56 PDTGeneralReplyAutomated scripts to import flat files into Teradata??I'd suggest TPT, it would be faster and efforts to setup that up is not much too. Also, if your tables are going to have the same structure from one project to another, you could parameterize ...
10602 Apr 2013 @ 01:11 PDTToolsReplyMoving Data from one box to anotherAre you looking for the best option to move only data or data with all the tables/views structure as well ? Also, approximately how much data we are talking about here ?
10502 Apr 2013 @ 05:46 PDTDatabaseReply"Replace" in Teradata - Only SQL statements ?Depends upon what you want to do, usually you can do it using different combinations of functions like, CASE WHEN, SUBSTR, LENGTH or CHAR_LENGTH, POSITION etc. If possible, post the...
10401 Apr 2013 @ 10:10 PDTDatabaseReplyINFORMATICA USES SECONDARY INDEXES?No, I don't think UPDATE TPT also supports unique SI.
10301 Apr 2013 @ 06:08 PDTDatabaseReplyReset rank when date interval exceeds limitYup, it would work perfectly.
10201 Apr 2013 @ 05:52 PDTDatabaseReplyselecting values from a table where max value is nullOne another option is to use CASE WHEN. To know what would work better, you can check EXPLAIN and compare the performance of different options.
10129 Mar 2013 @ 01:30 PDTToolsReplyPASING PARAMETERS TO BTEQ I think you can do it using dynamic sql and CALL DBC.SYSEXECSQL.
10029 Mar 2013 @ 12:56 PDTDatabaseReplyLoad clm with 12 hour time format What if you remove the cast of varchar ? Like, SELECT CAST('03/29/2013 12:00:00 PM' AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SSBT')
9929 Mar 2013 @ 05:51 PDTDatabaseReplyQuestions regarding Aggregate Join IndexWe had a similar kind of issue couple of years ago. What we did was something like vertical partitioning of the table. Meaning, created another table with the same keys and remaining columns t...
9829 Mar 2013 @ 05:47 PDTDatabaseReplyChanging Phone Number FormatYou can also try something like as it the phone number and lenght is going to be the same all the time - SELECT CAST((SUBSTR('999-999-9999',1,3) || SUBSTR('999-999-9999',5,3) ...
9726 Mar 2013 @ 12:13 PDTDatabaseReplyQuery for dropping a PPI columnOk, got your issue now. As you can't drop the column on which you have partitions, so you need to delete the partitions first. But I don't think you can remove all the partitions. So, I gue...
9626 Mar 2013 @ 10:13 PDTDatabaseReplyMerge SyntaxI'd suggest to CAST the 'last_update_dttm' to DATE as you are going to compare it with date(CURRENT_DATE) anyways, that should work.
9526 Mar 2013 @ 10:10 PDTDatabaseReplyINFORMATICA USES SECONDARY INDEXES?I meant, "not with unique* SI"
9426 Mar 2013 @ 10:09 PDTDatabaseReplyINFORMATICA USES SECONDARY INDEXES?If you are doing Fload or Mload with informatica then it would not work with secondary indexes. However, in Mload it would work with Non-unique SI, but not with SI.
9325 Mar 2013 @ 05:49 PDTDatabaseReplyQuery for dropping a PPI columnALTER TABLE.. MODIFY PRIMARY INDEX DROP RANGE BETWEEN...
9221 Mar 2013 @ 05:56 PDTDatabaseReplyMetadata information for a viewYou can try something like below - SELECT TOP 1 TYPE(col1),TYPE(col2),...,TYPE(coln) FROM dbname.viewname
9121 Mar 2013 @ 05:50 PDTDatabaseReplyData movement across Terdata serverI'd rank based on the performance like below - 2> TPT 1>ARCMain 3> Fast export/Fast Load
9021 Mar 2013 @ 05:47 PDTDatabaseReplyhow know the difference between compress table and general table ?I hope when you said "compress table", you meant the table with its column values compressed as there is nothing like compress table in teradata (as per my knowledge). And you c...
8920 Mar 2013 @ 12:42 PDTDatabaseReplyCompression in TeradataWhen you do INSERT-SELECT between 2 exact same tables then there is NO spool involved at all. That might be the reason when you match the datatype in table2 with table1, you do not get the spo...
8820 Mar 2013 @ 05:45 PDTDatabaseReplyWhat is compress? With example pls explain?What is use of compress?Here is really a good article on compress. It is an old article but will answer your questions. http://www.teradataforum.com/l020829a.htm

Pages