All forum activity

#DateUserForumTypeThreadPost
5879427 Jul 2016 @ 04:09 PDTglausonDatabaseReplyHow to Write the correct syntax for JoinNice analysis and explanation.  Thank you Fred.  I'll keep your query design comment regarding DISTINCT in mind for the future.  Being new to SQL, I'm learning new things eve...
5879327 Jul 2016 @ 03:05 PDTFredDatabaseReplyVolatile Table Vs Derived Table ... Which is best in terms of performance when used in a Join? - - Had a confusion..It depends. Derived table potentially allows for more global query optimization; volatile table gives you more control e.g. PI for data distribution. If the optimizer chooses to materialize the d...
5879227 Jul 2016 @ 02:57 PDTFredDatabaseReplyHow to Write the correct syntax for JoinThink about what the query you wrote is doing. You are joining each row from the first table with all rows in the second table that have the same Store, then doing it again with the third tabl...
5879127 Jul 2016 @ 02:40 PDTsandi99DatabaseReplyHelp Combing Two QueriesHi there Khurram...sorry...I am not exactly sure what you are looking for.  Could you please elaborate?  Thanks!  
5879027 Jul 2016 @ 02:31 PDTToddAWalterDatabaseReplyMultiload There are two different forms of delete in Multiload which may be the source of confusion.   Multiload Delete Task accepts a DELETE statement with a where clause intended to bulk delete the ...
5878927 Jul 2016 @ 01:44 PDTglausonDatabaseReplyHow to Write the correct syntax for JoinHi Khurram, Thank you for your comments - I have a feeling you're correct regarding the product join creating problems for the query.  As suggested, I included the WHERE clause; however, ...
5878827 Jul 2016 @ 12:20 PDTfeinholzToolsReplyDelimiter issue in FastloadThe Data Connector (we do not really refer to it as "legacy" since it is used by BTEQ, which is not a frozen product) does support quoted delimited data (as does FastLoad, MultiLoad and T...
5878727 Jul 2016 @ 10:29 PDTVSS NarayanaMurthy VedulaDatabaseTopicVolatile Table Vs Derived Table ... Which is best in terms of performance when used in a Join? - - Had a confusion..
5878627 Jul 2016 @ 10:27 PDTpkaDatabaseReplyConvert string into dateThanks Kbos. Concatenating zero and then casting to date format worked!  
5878527 Jul 2016 @ 09:51 PDTjohn9DatabaseReplyTPT ODBCThank you both for the reply ...i will check and get back to you.
5878427 Jul 2016 @ 09:24 PDTFredUDAReplyCollect Stats n Refresh StatsStats are important for source tables in the INSERT/SELECT query. Stats on the target table are not (unless that table is also a source).
5878327 Jul 2016 @ 09:10 PDTFredToolsReplyDelimiter issue in FastloadFastLoad, or more specifically the legacy Data Connector (PIOM) does not provide special handling for quoted data. Consider using TPT LOAD. The TPT Data Connector operator does support "optio...
5878227 Jul 2016 @ 08:57 PDTFredToolsReplynot Sign Delimiter issue in FastloadAdd -c UTF-8 option on the fastload command.
5878127 Jul 2016 @ 07:40 PDTM.Saeed KhurramDatabaseReplyMultiload Hi, There are a few differnces between Mload Import task and delete task.  In the delete task there is no acquisition phase, only application phase is used to delete rows. So th...
5878027 Jul 2016 @ 06:34 PDTabhishank18DatabaseTopicMultiload Does Multiload use worktables while performing Delete tasks ? I see two contradicting statements in multiload reference document. Please confirm.
5877927 Jul 2016 @ 06:16 PDTsravanaToolsTopicnot Sign Delimiter issue in FastloadHi All, In my flat file delimiter is “¬". This file I need to run in UTF8 format. Can any one of you guide me how to run fastload script in UTF8 form in windows command prompt...
5877827 Jul 2016 @ 05:44 PDTsravanaToolsTopicDelimiter issue in FastloadHi All, when I was loading CSV file into staging table by using Fastload getting below issue In my script delimiter is "," but few fields in CSV file was having comma (,) is a part of t...
5877727 Jul 2016 @ 03:43 PDTM.Saeed KhurramAnalyticsReplyQUERY IN ASTER Go through this article to get started with Aster: http://developer.teradata.com/aster/articles/using-aster-express-act-1
5877627 Jul 2016 @ 03:14 PDTM.Saeed KhurramDatabaseReplyNeed to get View Column derivation info from teradataYou will have to show the view definition to get the source of Cal_Val. If you need this info to automate something, you can use show view, extract tablename in some variable and use that variable...
5877527 Jul 2016 @ 02:44 PDTdrmkd17UDAReplyCollect Stats n Refresh StatsThanks Khurram ok. Will the insert append lag if stats are not collected between Runs?
5877427 Jul 2016 @ 02:31 PDTNewbieTDDatabaseReplyNeed to get View Column derivation info from teradataHi Saeed, Thanks for your info,   i want know from which table Cal_val is coming. i dont want to use help or show view statement. Is there any way??   Thanks,  
5877327 Jul 2016 @ 01:50 PDTM.Saeed KhurramDatabaseReplyNeed to get View Column derivation info from teradataI dont see much difference what you already have, except you want to use table name with column names. You can use the table alias for that as follows: repalce view DBV.Myview as locking table ...
5877227 Jul 2016 @ 01:43 PDTM.Saeed KhurramDatabaseReplyTPT ODBCThis has already been answered at https://forums.teradata.com/forum/tools/tpt17122-error-unable-to-connect-to-data-sourceoracle-using-tpt-script
5877127 Jul 2016 @ 01:39 PDTM.Saeed KhurramGeneralReplyHow to search multiple columns for specific texttry this: Select cm# from cm_databse where id1 = 'dl123' OR id2 = 'dl123' OR id3 = 'dl123'  
5877027 Jul 2016 @ 01:36 PDTM.Saeed KhurramDatabaseReplyHow to Write the correct syntax for JoinHi, The first thing is spool space issue occurs mostly when there is a product join in the query. As you are joining the store table with Transactions table, it may go for a product join. In your ...

Pages