#DateForumTypeThreadPost
28713 Dec 2013 @ 04:44 PSTDatabaseReplyhelp required for a update scenarioDid you try writing a SQL? If you are not getting the results then someone can lead you where you want to be after looking into the SQL...
28612 Dec 2013 @ 07:14 PSTAsterReplyLoad_from_teradata : problem with quote marks in the queryTry escaping the quotation mark by adding an additional quote sign before each one that you are using within the SQL query...  
28512 Dec 2013 @ 04:14 PSTAnalyticsReplyRound Up and Round to Nearest?Change the data type from decimal(8,2) to decimal(9,2) and it should work.  For details read through the following article... http://developer.teradata.com/tools/articles/how-many-digits-in-...
28411 Dec 2013 @ 09:38 PSTTeradata ApplicationsReplyFASTLoad to load UK companies house dataWhat error you are getting? Share the execution logs to know what issue you are facing!
28311 Dec 2013 @ 09:33 PSTDatabaseReplySkewed QueryThe index of the target table seems to be different and could be very non-unique. Check the uniqueness of the columns for the target table you identified as PI, how much non-unique they are?
28229 Oct 2013 @ 11:19 PDTDatabaseReplyqualify rank() over (partition.....questionUse the following quslify statement Qualify Rank(partition by OFFICE_ID, CAL_DT) =1 And filter the records based on the condition WHERE CLOSE_DT IS NOT NULL and LY_CLOSE_DT IS NOT NULL...
28129 Oct 2013 @ 10:28 PDTDatabaseReplyUPDATE Teradata Field with NULL valueYou wont be able to cast null as dates... You need to put NULL eithin your quited string instead of concatrnsting it with the string query, i hope it will work
28028 Oct 2013 @ 06:49 PDTDatabaseReplyProblem with CASE WHEN statementIn the last statement you have comma and a dot together between the columns is_pmt_official_y_n & total_ach_txn_cnt...
27927 Oct 2013 @ 04:09 PDTDatabaseReplywhich fields is populated which is empty in a tableHow about using recursive sql with dbc.columnd table to dynamically generate count sql, which you can execute again to get the desired results...
27826 Oct 2013 @ 12:46 PDTDatabaseReplyCount Days in a date fieldCan you explain in more detail what information you are looking for and how does your data looks like? May be if you share a sample dataset and expected results along with the query that you are w...
27726 Oct 2013 @ 12:42 PDTDatabaseReplyProblem with CASE WHEN statementMy two cent opinion... If you need the amount of days based on the last transaction date then why don't you subtract the last transaction date from current date... you will get the number of d...
27623 Oct 2013 @ 12:50 PDTDatabaseReplyExtracting Domain Names from EMAIL_TXT FieldSeems like these are just two decimal values which you are joining upon. Why do you think a simple join with equal sign won't work?
27519 Sep 2013 @ 03:16 PDTGeneralReplyHow would you access the table when simultanous loading is going on CAST(dt_colmn as date format 'YYYY-MM-DD')  
27416 Sep 2013 @ 11:31 PDTDatabaseReplySelect statements to get metadataThat is a lot of information for a single post :) Anyways, Teradata maintains quite a detailed information about its objects (databases, tables, views, columns, datatypes etc). You can start with ...
27316 Sep 2013 @ 03:22 PDTDatabaseReplyGet Row Count of a Table on a previous dateYou can calculate the size of row using the data types used in table definition and probably can do some maths to calculate the number of rows using currentperm consumed against the rowsize. You ca...
27213 Sep 2013 @ 12:50 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADURLs are generally alphanumeric strings... so of course you can use varchar!
27113 Sep 2013 @ 12:48 PDTDatabaseReplySelecting duplicate records from a table - Complete record and not just the duplicate keysWhy don't you run a test on some sample data????
27013 Sep 2013 @ 12:44 PDTDatabaseReplyFind table size and last access date I think you need to activate ObjectUseCountCollectRate in DBS control utility...
26913 Sep 2013 @ 12:38 PDTGeneralReplyCombine two queries into singleYou didn't mention in which format you need the resultset.... Single row with two columns or Two rows against one column. If you need two columns then the query mentioned by Khurram will work ...
26813 Sep 2013 @ 12:34 PDTGeneralReplyCASE STATEMENT TO VALIDATE VALID DATE DATATYPE FOR COLUMN ?Which TD version are you on? You can use the UDF ISDATE in the CASE statement to check whether the string provided is a valid date or not agsinst 20 different date formats... http://www.teradataf...
26713 Sep 2013 @ 12:26 PDTDatabaseReplyMSUM - use column name for query widthI doubt you can use the column name instead of the width. However, the use of MSUM is discouraged in Teradata, and you should prefer to use SUM window function... SUM(SAL) OVER(ORDER BY PDAY RO...
26612 Sep 2013 @ 10:44 PDTGeneralReplySQL return code in stored procedure in TD14I will check this on TD 14 environment but in Teradata, return code ZERO means the execution was successful without any warnings or errros. I don't think this has changed in TD 14.  BTW r...
26512 Sep 2013 @ 10:27 PDTGeneralReplyCan we get date format as MMM'YYTry this SELECT CAST(CAST(CURRENT_DATE AS DATE FORMAT 'MMM') AS CHAR(3)) || '''' || CAST(CAST(CURRENT_DATE AS DATE FORMAT 'YY') AS CHAR(2))  
26412 Sep 2013 @ 10:02 PDTMarketing & CRMReplyManaging Control Groups within TCRM ApplicationYes multistep functionality was available in TCRM v5.2. You can design the multistep communication in the comm designer but to execute you need to setup the big batch (you need to go through the TC...
26311 Sep 2013 @ 11:32 PDTDatabaseReplyGet Row Count of a Table on a previous dateI don't think that is possible unless you have some metadata capturing process defined capturing table details before and after execution of the loading jobs...

Pages