#DateForumTypeThreadPost
1531 Aug 2015 @ 09:04 PDTDatabaseReplyMethod to find number of occurence of specific character in a stringThanks Ranga & Sakthi, your answers really help, but is there a funtion or regexp we can identify this in single go?
1428 Aug 2015 @ 01:18 PDTDatabaseReplyNeed to re-write delete statement DELETE AA FROM IMPORT_REFER_F AA, IMPORT_REFER_S BB, IMPORT_REFS_F_GT CC WHERE  AA.JOB_ID = BB.JOB_ID AND AA.JOB_HEADER_ID = BB.JOB_HEADER_ID AND AA.JOB_LINE_NUM = BB.JOB_LINE_NUM A...
1328 Aug 2015 @ 12:06 PDTDatabaseTopicMethod to find number of occurence of specific character in a stringIs there method in teradata to find number of occurence of a specific character in a string? Like if string value =  ' Teradata is Relational Database' I need to know how many time l...
1228 Aug 2015 @ 11:55 PDTGeneralReply1 MB data block size in 14.10Increasing Block size could help when retrving bulk contiguous records, as more # rows fit in a huge data blocks, we can save on IO. At the same time it has its minuses, if the the number...
1128 Aug 2015 @ 11:51 PDTDatabaseReplyhow to find the unique column(s) in a tableUse Show View statements to find the underlying tables, then please apply the above SQL to find the unique columns in those tables.
1028 Aug 2015 @ 11:48 PDTDatabaseReplyhow to join multiple tables in Teradata CREATE MULTISET TABLE SANDBOX.TEST1 ( C1 int , C2 int ) Primary index (c1) ; CREATE MULTISET TABLE SANDBOX.TEST2 ( D1 int , D2 int ) Primary index (c1) ; CREATE MULTISET TABLE SANDBOX.TEST3 (...
928 Aug 2015 @ 09:32 PDTDatabaseReplyStored procedures problemYou Should be able to create the stored proc, I just copied your code and ran in my env, the stored proc gets created without any issues. Can you please let me know what error it throws while creat...
826 Aug 2015 @ 07:11 PDTGeneralReplySQL (combine multiple insert-sel statements into one ) INSERT INTO FACT SEL  LOAD_DT ,key_id ,S_id ,device_id ,seg_id ,insight_id ,CASE WHEN T2.ROW_NUM =1 THEN 5040    WHEN T2.ROW_NUM=2 THEN 5050    EL...
725 Aug 2015 @ 11:45 PDTDatabaseReplyNeed help on deleting duplicate records of a intraday runif it is a stage table, we can delete the records after they are loaded into main table right? so your table will only store records which are only need to be processed. load new records with flag...
625 Aug 2015 @ 11:27 PDTDatabaseReplyStatistics vs Secondary Index on a TableThese are 2 differenct concepts. Coming to Secondary indexes it can be either unique or non unique, NUSI are used by the optimizer only if it finds better way compared to FTS, usuall...
524 Aug 2015 @ 01:08 PDTDatabaseReplyMerge and update errorTo choose 1 row between the duplicates should be a business call which ultimately defines the unique key of the record, with which you can create unique secondary index or re-create ...
424 Aug 2015 @ 11:25 PDTDatabaseReplyMerge and update errorIf your first time run had duplicate rows (at least on keys), this problem would occur. During the first time run the duplicate rows are inserted without any issues, while running for the seco...
318 Aug 2015 @ 07:50 PDTDatabaseReplyCPU Secs for a stored ProcedureDid you try query band for the transcation inside your Stored Proc ?
217 Jul 2015 @ 11:37 PDTDatabaseReplyBackup and Restore only statistics in TeradataWe can copy stats from from one table to another only if the stuctures are exactly same. copy stats feature can be really helpful when you are trying to alter a huge table. we really need not go f...
127 May 2014 @ 02:30 PDTToolsTopicTeradata - Fast Export OptionWhile executing Fast Export, we have a option to create a MLOD script by provoding the MLSCRIPT. Do we have a similar option for FASTLOAD? Can someone help me know if there is one. Or let me know w...

Pages