All forum activity

#DateUserForumTypeThreadPost
5956701 Sep 2016 @ 02:14 PDTdnoethDatabaseReplybetween condition make bad execution planThere's no way to avoid the product join because it's not an equi-join.   What are you trying to achieve? Table A is probably a calendar and you'll get multiple rows for each ro...
5956601 Sep 2016 @ 12:09 PDTknowledgeDatabaseTopicbetween condition make bad execution plan Hi,   i have a query like this:   sel * from tbla a inner join tblb b on a.TheDay between b.SDay and b.EDay;   this is the execution plan:   2...
5956531 Aug 2016 @ 11:34 PDTkrishna1985DatabaseTopicInsert taking longHi Gurus,   I have the below script everything works well but at the bottom of the script we have insert in to statement ie for UDRBSCMS.RCD_TPB_OVERALL_DECISION and its taking ages to ...
5956431 Aug 2016 @ 11:25 PDTkrishna1985ToolsReplyMULTILOAD BUFFER ERROR!!! urgentHi Ivyuan,   thanks for getting back to me. Acutally there was issue with the tab space. we had extra tab hence the column got shifted to other and so forth...now its resolvd.
5956331 Aug 2016 @ 07:06 PDTjody_larsenToolsReplyTPT and Windows PowerShellI was running into this issue as well...  For some reason launching powershell and typing the following at the command prompt:   tbuild throws this error.  However, the following d...
5956231 Aug 2016 @ 04:59 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityThanks Tom!  I'll see about getting our client to do as you've suggested.
5956131 Aug 2016 @ 03:58 PDTfirstcaptainTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsI am seeing the same problem, I have installed    java version "1.8.0_101" Java(TM) SE Runtime Environment (build 1.8.0_101-b13) Java HotSpot(TM) 64-Bit Server VM (build 25....
5956031 Aug 2016 @ 02:31 PDTCvinodhToolsTopicTDCH: escapedby and enclosedby I am not able to use enclosedby and escapedby arguments in Teradata hadoop connector. I get the following error when I pass these arguments. here I am trying to set enclosedby wit...
5955931 Aug 2016 @ 12:46 PDTToddAWalterData ModelingReplyHow to transform an LDM to a PDM / Building block or Datamart?Either - depends on the bsuiness requirements. Generally the business requires the history of an account so it would be likely that Account is defined to save the expired rows. Events however often...
5955831 Aug 2016 @ 11:57 PDTraddatz.dennis@gmail.comData ModelingReplyHow to transform an LDM to a PDM / Building block or Datamart?Are the iLDM models intended to be physically architected as updateable or as insert only? For example, would you update ACCOUNTS or EVENTS or always expire and add new rows?
5955731 Aug 2016 @ 11:00 PDTdnoethDatabaseReplySingle vs double quotesIt's working as expected by Standard SQL (and similar in most DBMSes): Single quotes oare string delimiters. Double quotes are used for identifiers like column & table names. But in Terad...
5955631 Aug 2016 @ 10:57 PDTPrashant_20986DatabaseReplyTable A Left Outer JOIN Table B VS Table B Right Outer JOIN AThanks
5955531 Aug 2016 @ 10:56 PDTdnoethDatabaseReplyTable A Left Outer JOIN Table B VS Table B Right Outer JOIN AYes, it's only a syntax variation.
5955431 Aug 2016 @ 10:46 PDTteradatatesterDatabaseReplyUsing WITH Statement Modifier instead of Temp Tables?Did DR160077 get resolved?
5955331 Aug 2016 @ 10:36 PDTSGITDatabaseTopicSingle vs double quotesHello, in the following code , if i replace the single quotes arounf 'credit card' with double quotes, it looks for a column with name 'credit card' . can some one throw some light ...
5955231 Aug 2016 @ 10:22 PDTalokku55GeneralReplyinterview helpI see everyone sharing their email ids. Please let me know if anyone has really got those interview questions.
5955131 Aug 2016 @ 09:42 PDTfgrimmerTeradata StudioReplyViews the rows being transferred overgs, Please open an incident with Teradata Support so we can gather the logs and configuration information to fix the problem. thanks.
5955031 Aug 2016 @ 09:41 PDTfgrimmerTeradata StudioReplyNeed to reinstall Studio Express 15.10.1 (last working version): where to find it?Please contact Teradata Support, T@YS, https://tays.teradata.com to help reach the Teradata Patch Server.
5954931 Aug 2016 @ 09:39 PDTjv02GeneralReplyinterview helpHi,  Please forward the question to jegathesv@gmail.com
5954831 Aug 2016 @ 09:36 PDTfgrimmerTeradata StudioReplyConfigurer Data Transfer Error FilesRavindra, Please open an incident for this so we can gather the logs and configuration information to help fix this issue.
5954731 Aug 2016 @ 09:18 PDTPrashant_20986DatabaseTopicTable A Left Outer JOIN Table B VS Table B Right Outer JOIN AIs Table A LEFT OUTER JOIN TABLE B same as TABLE B RIGHT OUTER JOIN TABLE A in in terms of output and performance? (Regardless of data content and size of table A, and table B)
5954631 Aug 2016 @ 08:03 PDTnealvennaDatabaseReplyReplacing tableSAS work tables and Teradata Volatile tables are similar in a way that both exists only for Session.  SAS allows to replace tables if they already exist, Teradata does not. You need to do what...
5954531 Aug 2016 @ 07:56 PDTnealvennaDatabaseReplySet multiple variable in one case statement Hi,  Code in SAS is a do loop. If you want to achive same thing then use 2 case statements, which is simple and easy solution. case when RFRL_SRC_CD = '039' then 1 end var_firs...
5954431 Aug 2016 @ 07:28 PDTDinesh1975DatabaseReplyMAX SPOOL BY AMPAny one please respond.
5954331 Aug 2016 @ 06:57 PDTtomnolanConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityTo cover this feature request, I created JDBC RFC 183490 "Connection parameter MAYBENULL for ResultSetMetaData.isNullable variant behavior".   If you're a customer, you can use...

Pages