#DateForumTypeThreadPost
2814 Mar 2016 @ 11:53 PDTTeradata StudioReplyTeradata preferences for new connection profile type missingThank you. It helps.
2711 Mar 2016 @ 01:13 PSTTeradata StudioReplyTeradata preferences for new connection profile type missing@fgrimmer: Thank you for helping me in another thread. I am here because i have a question related to running  Oracle  Queries using TD Studio Express. I understand that to run Oracle Qu...
2611 Mar 2016 @ 12:01 PSTTeradata StudioReplyHow get the Hadoop System option in New Connection Profile.@fgrimmer: Thank you for the infiomatin ie  Studio Express 15.11  will support Cloudera. We will wait for it. For Horton Work connection profile i could see KNOX and JDBC.  Can...
2511 Mar 2016 @ 08:52 PSTTeradata StudioReplyHow get the Hadoop System option in New Connection Profile.@fgrimmer:  We are tryiing to rollout Teradata Studio Express for all the users. I would like to present it to all the audiance and talk about good thing. What we can do in Express. Some of th...
2410 Mar 2016 @ 06:30 PSTTeradata StudioReplyHow get the Hadoop System option in New Connection Profile.@fgrimmer: I would like to know why Teradata Studio Express does not support hadoop? I could see there is a connection for HDP but Genric Hadoop system shows as Unsuported.   My understandi...
2309 Dec 2015 @ 09:39 PSTDatabaseReplyvery fast query + very fast query = very slow query ???Can u try below Query:   select r.* from our_dw.sales_detail r where r.InventoryCode in (select InventoryCode from our_dw.inventory_summary where ItemDescription lik...
2229 Sep 2015 @ 04:44 PDTDatabaseReplyTactical WorkloadWork load management works on optimizer estimation before run. If your query is running a differnt workload rather than tactical then check the query explain plan and see if the estimation meets th...
2108 Sep 2015 @ 01:50 PDTPrivate Forum
2008 Sep 2015 @ 12:29 PDTPrivate Forum
1908 Sep 2015 @ 04:32 PDTDatabaseReplyNeed a query It is (A-B) union (B-A). You can write it many ways
1803 Sep 2015 @ 03:33 PDTPrivate Forum
1702 Sep 2015 @ 06:11 PDTPrivate Forum
1602 Sep 2015 @ 05:37 PDTDatabaseReplyNeed Column Name with Longer than 30 CharactersDave is correct. You need to utilize EON which is supported by 14.10. There is a DBS control flag which needs to be set and database restart is must.
1502 Sep 2015 @ 05:28 PDTDatabaseReplyTable Size/NoPI vs PIFrom your test it looks like it matches what i said before but your conclusion is not correct. IF you will insert to NOPI table using relational connection even though it will run for years ;) your...
1402 Sep 2015 @ 09:26 PDTDatabaseReplyTable Size/NoPI vs PIHave you Inserted NOPI to NOPI table? or PI to NOPI table?  For above two cases  Inserts are AMP local  so you should not see much difference in size between source table with targe...
1311 Aug 2015 @ 07:43 PDTDatabaseReplyView creation.It is necessary to have a view layer in TD with locking row for access. Your code does not have that. It may create lock contention when more than one users want to access same table uisng the view.
1211 Aug 2015 @ 06:29 PDTToolsReplyTPT Question: Read two files simultaneously and write to TableSteve, Thanks for the reply. I also figured out the same with all my testing. I have a question specific to TPT LOAD.  Requirement: File A =====             &...
1110 Aug 2015 @ 11:01 PDTPrivate Forum
1003 Aug 2015 @ 05:46 PDTToolsTopicTPT Question: Read two files simultaneously and write to Table TPT Question Can i do perform below tasks in TPT if yes how? I will be using multi threads as there are 120 sets of files to read for each set and load will process 4.8 billion records. ...
909 Jun 2013 @ 06:24 PDTPrivate Forum
808 Jun 2013 @ 12:03 PDTPrivate Forum
707 Jun 2013 @ 02:24 PDTPrivate Forum
602 May 2013 @ 07:57 PDTPrivate Forum
530 Apr 2013 @ 10:10 PDTPrivate Forum
412 Oct 2012 @ 01:51 PDTPrivate Forum

Pages