#DateForumTypeThreadPost
8719 Mar 2013 @ 01:52 PDTToolsReplyDate Format In Teradata SQL AssistantLooks like the last row is always the latest record of the 'name' column. In that case, it would be like below. Select Name, max(create_time) If that is not the case then you can use ROW_...
8619 Mar 2013 @ 11:36 PDTDatabaseReplyPerformance considerations during taking back up--You are right, I meant, CREATE TABLE AS (SELECT..) only. I never tried "CREATE TABLE AS existing_table" but it's good to know that it copies all the indexes, will use that from next ...
8519 Mar 2013 @ 10:00 PDTDatabaseReplyPerformance considerations during taking back up--One thing I'd like to mention about scenario # 1 ( create table as existing table with data) that if your existing table has few PIs, SIs, partitions then teradata would not crea...
8419 Mar 2013 @ 09:48 PDTDatabaseReplyHow to retrieve the Relative Record Number?If you do not care about the HHMISS (last 6 digits of your numeric_column) then you can do the same that you did in excel by using SUBSTR function and fetch only first 8 and assign the name to it a...
8319 Mar 2013 @ 06:20 PDTDatabaseReplyTemporal usage classic scenerio You can add your SET statement like below - SET VT = PERIOD(BEGIN(VT), source_date_column)  
8218 Mar 2013 @ 12:16 PDTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentYou need to RANK on all these columns on which you need to do grouping. Keep adding them into order by clause and you will get rank based off of the unique combination of all the columns that you n...
8118 Mar 2013 @ 12:04 PDTToolsReplyBTEQ not remove trailing blankYou can create a new task in informatica and in the properties you can add - exec macroname .. and run that task using informatica (assuming you have all setup connection already existing between i...
8015 Mar 2013 @ 01:24 PDTDatabaseReplywhy mload accepts duplicates and why dont fastloadFor the basic understanding of fastload and mload and to get answer of your questions, you could use below link. Just keep hitting next and you will get all the required details about fastload, mlo...
7915 Mar 2013 @ 01:20 PDTDatabaseReplyData From Vendor ChangesI tried hard to find out what is your question or issue here, but not able to, can you please put what's your challenge ?
7815 Mar 2013 @ 10:12 PDTDatabaseReplyStats collection inside SP'sHere is one simple example - REPLACE PROCEDURE DBNAME.PROCNAME() BEGIN COLLECT STATISTICS TBNAME COLUMN COL1; END;   CALL DBNAME.PROCNAME(); What kind of error do you get when you t...
7715 Mar 2013 @ 08:36 PDTGeneralReplyWith Recursive - how to filter duplicate records?I think to find out the last level, you first need to create rank based on mgr_id, emp_id and staff_id and put it in employee table/view. Let's call is 'RNK'. Once that is done, you can...
7615 Mar 2013 @ 07:58 PDTDatabaseReplyStats collection inside SP'sYes, it is possible to collect stats for volatile tables inside stored procedures.
7515 Mar 2013 @ 05:45 PDTDatabaseReplyPerformance tuningNo it doesn't make a difference how you do INNER JOIN, it would be same.
7414 Mar 2013 @ 05:58 PDTAnalyticsReplyPlease give syntax of scalar subquery to join three tablesAs you haven't mentioned the table names or columns to join them, I have put generic query below. You can change it as per your requirements. Also, not sure why you want to use scalar subquery ...
7314 Mar 2013 @ 05:43 PDTGeneralReplyError in running macro with teradata connectionI don't think it is Teradata error. ERROR 180-322 is a SAS error.
7212 Mar 2013 @ 05:40 PDTToolsReplyTeradata export to DB2 using TPTOLELOAD has that option. I am able to export to DB2 using it, I use ODBC connection and it fast exports it to DB2 tables. However, in TPT, I do not see that option. To export, I see only to ei...
7111 Mar 2013 @ 09:54 PDTToolsReplyFilter using OLELOADNevermind..found the solution.
7011 Mar 2013 @ 05:54 PDTDatabaseReplyLENGTH() function in bteqTry character_length function instead of length.
6908 Mar 2013 @ 09:00 PSTToolsTopicFilter using OLELOADHi, I am trying to do FastExport using OLELOAD utility. Can I filter the source data before I export it to another database ? I do not see that option anywhere. I see that before it fast exports, i...
6808 Mar 2013 @ 08:11 PSTToolsTopicTeradata export to DB2 using TPTHi, is it possible to use TPT utility to export the data from the teradata table to the table of AS400 (DB2) ? If yes, please let me know how as I am not able find that option under 'Job D...
6707 Mar 2013 @ 01:31 PSTToolsReplyColumn and Row separator in MultiloadYou can use FILLER with CHAR(1) at the end.
6606 Mar 2013 @ 05:45 PSTDatabaseReplyCrash Code 3701 encountered while creating a volatile tableI think you need to open a bug with Teradata support team. The reason it is telling you not to resubmit it because if you run it again teradata will hit the same BUG again and every time&...
6505 Mar 2013 @ 02:15 PSTDatabaseReplyRounding down decimalsSELECT CAST(columnname as integer)
6404 Mar 2013 @ 01:29 PSTDatabaseReplySurrogate Key QuestionYou can try something like below - SEL CSUM(1,(ADDR.ADDRESS_LINE1 || ADDR.ADDRESS_LINE2 || ..) ) + DT.MAX_ADDRESS_ID AS ADDRESS_ID FROM SOURCE.ADDRESS_TABLE ADDR, (SEL ZEROIFNULL(MAX(ADDRESS_...
6304 Mar 2013 @ 01:06 PSTDatabaseReplyDIFF BETWEEN PRIMARY KEY AND PRIMARY INDEXThat's a good news. I am trying again here. PRIMARY KEY PRIMARY INDEX 1 It cannot be NULL It can be NULL 2 It is not man...

Pages