All forum activity

#DateUserForumTypeThreadPost
2439810 Apr 2012 @ 02:28 PDTmjjDatabaseReplyHelp on 7 days average - advance sql Hope this help: select "date", count(user_id) over (partition by "date" order by "date" rows between 7 preceding and current row) from x1 Rgds,
2439710 Apr 2012 @ 01:35 PDTchinthucsToolsReplyTeradataParallelTransport API Table Schema Mismatch Error Ya sure We use putbuffer function only.Not both functions at a time. We have exported data from the teradata table to formatted file using fast export utility . Using that file,We load t...
2439609 Apr 2012 @ 10:47 PDTkirandhobaleTrainingReplyWant Teradata SQL Tutorial Hi Paresh, This is Kiran, I am interested in learning teradata, please suggest me the books/websites i have to refer, i would be very thankful ,if any of u send me the materials.. , ...
2439509 Apr 2012 @ 10:31 PDTprathyusha_dTrainingReplyWant Teradata SQL Tutorial Hi I am planning to write Teradata12 Basics certification. Please guide me for the preparations and share if any material or sites. my id is prathyu.d@gmail.com Please do reply ...
2439409 Apr 2012 @ 10:28 PDTprathyusha_dTrainingReplyWant Teradata SQL Tutorial Hi I am planning to write Teradata12 Basics certification. Please guide me for the preparations and share if any material or sites. my id is prathyu.d@gmail.com Please do reply ...
2439309 Apr 2012 @ 10:28 PDTprathyusha_dTrainingReplyWant Teradata SQL Tutorial Hi I am planning to write Teradata12 Basics certification. Please guide me for the preparations and share if any material or sites. my id is prathyu.d@gmail.com Please do reply ...
2439209 Apr 2012 @ 10:25 PDTprathyusha_dTrainingReplyWant Teradata SQL Tutorial Hi Am planning to write Teradata12 Basics certification please guide me for the preparation and any kind of material. my id is prathyu.d@gmail.com Please Do reply. Thanks in Adva...
2439109 Apr 2012 @ 04:32 PDTPrivate Forum
2439009 Apr 2012 @ 02:33 PDTmattitDatabaseReplyQUALIFY ... OVER (PARTITION BY ...) phrase The description didn't help much.  IHowever, 've found a little more.  The PARTITION BY is equivalent to a GROUP BY clause.  I'm still kind of stuck on the purpose of ...
2438909 Apr 2012 @ 02:03 PDTrsumardyDatabaseTopicHelp on 7 days average - advance sql hi, I have simple table: date user_id 20101011 adam 20101011 bob 20101013 adam 20101013 courtney 20101014 bob 20101018 adam   I tried to calculate co...
2438809 Apr 2012 @ 11:07 PDTfeinholzToolsReplyTeradataParallelTransport API Table Schema Mismatch Error Well, we definitely need more information than this. Are you saying that when you use putrow() instead of putbuffer(), you do not get this problem? Are you sure you are building the buff...
2438709 Apr 2012 @ 09:04 PDTksaikrishnaGeneralReplyWelcome to the Teradata Developer Exchange discussion forums! Hi, Can anyone guide me how to find the Parent and child relationship between tables in teradata.   Thanks in advance.
2438609 Apr 2012 @ 06:32 PDTchinthucsToolsReplyTeradataParallelTransport API Table Schema Mismatch Error I forget to add one thing in previous comment.We are using putbuffer function to load data into terradata database.The same data is loaded usung putrow function in row by row basis.But when we a...
2438509 Apr 2012 @ 03:14 PDTseedhavalDatabaseReplyCharacter Truncation Hi, try this: SELECT t.outputstr FROM (    SELECT       POSITION('.' IN ip) AS POS1       ,POSITION('.' IN...
2438409 Apr 2012 @ 02:51 PDTmadeelusmanGeneralTopicSample database Hello, Thanks God, fianlly i find out how to post my question on this forum. i like to advise please make it simple. well, i'm new newbie in teradata. i have install Teradata expres vers...
2438309 Apr 2012 @ 02:01 PDTMahsDatabaseReplyValue ordered secondary index vs Partitioned primary index I can say its highly selective and this condition is accountable to calculate aggregated data across each period, in a sense this condition is going to retrieve almost 100% data .  
2438208 Apr 2012 @ 11:17 PDTAshokks_85DatabaseReplyAvoiding spool space error Hi Chandra, Thanks for the response!!! Yeah.. we can try loading the data into three different stage tables. But at the end of it only when i have all the data from the three stage table...
2438108 Apr 2012 @ 02:17 PDTbutchecConnectivityReplyCan I switch between LDAP and Standard Authentication? A significant question is are you doing ldap authentication only, or authentication and authorisation.  Recommend authentication only as this requires an internal user that is implicitly ma...
2438008 Apr 2012 @ 01:58 PDTChandrashekarksDatabaseReplyAvoiding spool space error Hi,          Just giving my try.... Load the data to three work tables (try with same partition used to load stage - 8 months ...
2437907 Apr 2012 @ 04:09 PDTsuhaguideTrainingReplyWant Teradata SQL Tutorial If you want to now more about Teradata SQL Reference,  Visit http://www.teradata-sql.blogspot.com  for your reference.
2437807 Apr 2012 @ 12:13 PDTAshokks_85DatabaseTopicAvoiding spool space error Hi, Here is the scenario of the issue. 1. I have a btq which takes data from a source table having billions of rows.  from the source i take only 2 years of data and load it into a ...
2437707 Apr 2012 @ 07:54 PDTDhaniTrainingReplyTeradata 12 Certification I am Teradata faculty from hyderabad. Expert in v2r5, v2r6, TD12,TD13,TD13.10, TD14(currently being developed) releases. contact me at dhan_raj_80@yahoo.co. for online cla...
2437607 Apr 2012 @ 07:46 PDTterausr123ConnectivityTopicConnection Reset when clicking on Session Info I have installed Teradata Express 13 on Windows 7, 32 Bit. After the installation I start Teradata Service Control and click on "Start Teradata!". After a few seconds it is started. ...
2437507 Apr 2012 @ 03:41 PDTJanayTylerConnectivityTopicMORE HEREhello there
2437406 Apr 2012 @ 01:59 PDTbrydgeskConnectivityTopicVisual Studio 2010 Do people actually have the .NET Data Provider for Teradata integrated in Visual Studio 2010? I know you can add a reference to the driver and write code against it, that works fine. I'm tal...

Pages