#DateForumTypeThreadPost
21206 Feb 2013 @ 02:50 PSTGeneralReplyRegarding the Secondary Indexa c
21106 Feb 2013 @ 01:31 PSTDatabaseReplyHow to retrieve the Relative Record Number?Have you tried ROW_NUMBER function?
21006 Feb 2013 @ 01:11 PSTGeneralReplyConverting Range values in a column into Separate rowsThis SQL could be your starting point converting the range values into separte rows and tune it according to your requirements... CREATE SET TABLE tbl ,NO FALLBACK , NO BEFORE JOURNAL, ...
20906 Feb 2013 @ 12:38 PSTAnalyticsReplyHow to not to skip a RANK ?If I understand correctly, you just want top 100 values according to the sales so you can put a limit using QUALIFY clause... SELECT STORE, ITEM, SALES, ROW_NUMBER() OVER(PARTITION BY SALES ORDE...
20806 Feb 2013 @ 12:24 PSTToolsReplysql assistant 13.10 - Show definition window wont closeI am using v 14, and it works fine...
20705 Feb 2013 @ 12:07 PSTAnalyticsReplyHow to not to skip a RANK ?Use ROW_NUMBER() It has the same syntax as RANK but assigns incremental values in case of same rank value...
20604 Feb 2013 @ 01:01 PSTToolsReplyDuplicate rows in MLoad?Hi raghu45, All the duplicate rows will be updated because thats what you asked for in the SQL. Regards,
20504 Feb 2013 @ 12:57 PSTToolsReplyDuplicate rows in MLoad?Hi barani_sachin, NOPI tables are inherently MULTISET, and because the row distribution is not based on any index they so it is possible that they can reside on a different AMP so duplicate row ch...
20401 Feb 2013 @ 08:24 PSTDatabaseReplyOptimizer choses different path when a meaningless group by is added to a dreived tableGroup by <<comma separated list of column names>>
20331 Jan 2013 @ 02:30 PSTDatabaseReplyHow to extract column names from a table using Teradata SQLYou can create the alias names for the tables/views in SQL statement but not for the database...
20231 Jan 2013 @ 02:29 PSTGeneralReplyHow to check which data has an errorerr1 table is created for any translation errors or constraint violations, a row containing the wrong data type would be captured in err1 table. You need to see whether the casting of the records i...
20130 Jan 2013 @ 12:15 PSTDatabaseReplyCASE statement inside Store ProcedureYou will see this error normally when the SQL statement in the SP are not terminated with semicolon. Can you share the table ddl alongwith the SP definition to have a look as what could be missing....
20030 Jan 2013 @ 11:31 PSTGeneralReplyIs there a limitation on the Merge statement and Rank Function?As far as I remember the COLAESCE function causes problems in the joining condition in MERGE statement. Did you try without using the COALESCE statement?
19929 Jan 2013 @ 12:39 PSTDatabaseReplyInsert multiple rows in single statementTeradata database manaul should give you enough information to understand these options in more detail. Did you try looking there?
19829 Jan 2013 @ 12:33 PSTToolsReplyDuplicate rows in MLoad?Absolutely correct, if the table is NOPI then fastload shouldn't have any issue loading the duplicates...
19729 Jan 2013 @ 01:18 PSTDatabaseReplyERROR 3070 when creating a tableFirst of all you need to take out the AS keywords before the data type name. Secondly VARCHAR(MAX) is not a datatype - you need to mention some numeric value instead of MAX. Something like this w...
19629 Jan 2013 @ 01:02 PSTAnalyticsReplyUsing different date formatsNo it shouldn't...
19525 Jan 2013 @ 09:22 PSTToolsReplyDuplicate rows in MLoad?Yes, MLOAD supports the insertion of deuplicate records and this is the main difference between the FASTLOAD and MULTILOAD. The below thread should give you more details... http://forums.teradata...
19425 Jan 2013 @ 09:11 PSTToolsReplyError during FloadI guess you need to share the script in order for someone to figure out the problem!
19323 Jan 2013 @ 12:02 PSTDatabaseReplySpace in the databaseYes, the wastage is at the Table level and thats why the selection of PI is important to avoid skewness. MAX(CurrentPerm) * (HASHAMP()+1) should give you a more realistic estimates!
19222 Jan 2013 @ 10:53 PSTDatabaseReplyOracle Connect by Equivalent function in TeradataI believe that in Oracel START WITH... CONNECT BY clause is used to select the hierarichal data. Teradata doesn't support this clause but you can achieve similar functionality by writing Recurs...
19121 Jan 2013 @ 12:14 PSTDatabaseReplySpace in the databaseYes thats the correct understanding. If the database has been allocated 50 MB of space on a 50 AMP system, this means each AMP can store max of 1 MB, so if the space on one AMP is exhausted then th...
19019 Jan 2013 @ 11:49 PSTDatabaseReplyGetting startedDepending on the usability of the system one has the advantage over the other, e.g. for OLTP systems you get much better performance in Oracle than Teradata but for OLAP systems Teradata has advant...
18919 Jan 2013 @ 11:46 PSTDatabaseReplyHyperlink in teradata table The hyperlinks are basically the character string. So you can define the field as VARCHAR and insert the hyperlink in the field, there shouldnot be any difference in hyperlink text and normal text....
18819 Jan 2013 @ 11:41 PSTTeradata ApplicationsReplySQL to pull dataKumar, You can get the records from dbc.columns but you will have to join the table dbc.table to filter out the views and tables by putting the condition dbc.tables.tablekind = 'T' oth...

Pages