3526 Mar 2008 @ 09:09 PDTUDAReplyPerformance TuningHi,Can you provide a li'l more info. Can you provide the table structures so see the primary indexes. And also highlight which of these tables are "look-up" tables?
3418 Feb 2008 @ 02:00 PSTDatabaseTopicALTER TABLE and transient journalHi,I need to rename a few columns of a very large table, with close to a billion rows. So, does using ALTER TABLE to rename the column names require Transient journalling (in which case the ALTER T...
3306 Nov 2007 @ 11:51 PSTDatabaseReplySoft Referential IntegrityThank you all for the info.
3206 Nov 2007 @ 12:45 PSTDatabaseTopicSoft Referential IntegrityHi, Can anyone tell me whether is there any difference in the soft referential integrity constraints in V2R5 vs V2R6?Besides, does soft RI also involve additional internal maintenance like regular ...
3128 Feb 2007 @ 06:39 PSTAnalyticsReplyTeradata for forecasting ?Thanks Tim. Let's wait and see if anyone has actually used a NCR-made forecasting tool on TD.
3020 Feb 2007 @ 09:17 PSTAnalyticsTopicTeradata for forecasting ?Hi all,Has anyone used any Teradata tool/application for developing forecasting models.Please let me know your opinion on this.Thanks.
2912 Oct 2006 @ 01:03 PDTDatabaseReplycontinue question:(on table newly changed)You can query the dbc.tvm table or the dbc.tables view with a condition on the lastAlterTimestamp.
2820 Jun 2006 @ 06:22 PDTDatabaseReplyQueue Tables / SELECT AND CONSUME TOP NJust managed to get the create table syntax correct, and created the following queue table:create table quetable2, queue(create_timestamp timestamp(6) not null default current_timestamp(6), a int, ...
2720 Jun 2006 @ 06:11 PDTDatabaseTopicQueue Tables / SELECT AND CONSUME TOP NHi all,I remember that there is the concept of Queue tables in Teradata V2R6, using which we can run a SELECT AND CONSUME TOP 1 from tablename. But i dont seem to get the syntax correct, nor am i a...
2612 Jun 2006 @ 10:27 PDTDatabaseReplyMigrating to V2R6Yes, Installing TTU8 is must.
2512 Jun 2006 @ 10:08 PDTDatabaseReplyQuestion Regarding from sub tables?Yes, sub tables are used by the Optimizer/Hashing algorithm to reach the actual base tables, but a user cannot auery a sub table directly.
2427 Mar 2006 @ 07:42 PSTDatabaseReplysth wrong when logon on BTEQAdd the following line to your hosts file:YOUR_COMP_IP_Address demotdat demotdatcop1to get your comp ip, type in ipconfig from cmd, and you will get it.
2324 Mar 2006 @ 01:06 PSTDatabaseReplyDates and Foreign KeysYou can considering partitioning your table on the data field.
2224 Mar 2006 @ 01:05 PSTDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.No, you dont have anything thats same as Sequence of Oracle.
2123 Mar 2006 @ 02:43 PSTToolsReplyTPump vs MLoadFound an informative read at http://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=10&MessageID=3566
2023 Mar 2006 @ 02:12 PSTToolsTopicTPump vs MLoadHi All,Till date I have just been using Mload. But at the moment, i am considering the implications of using TPump for a new data load of approximately 75 million rows per day. The TD Manual on TPu...
1922 Mar 2006 @ 01:40 PSTDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.This also works:insert partitbl (k)SELECT sum(1) over (rows unbounded preceding) As ROW_ID from dbc.databases;
1822 Mar 2006 @ 01:15 PSTJobsReplyTeradata Professional needed (South Africa)Appreciate if you can mention your work-id (outlook id) rather than yahoo or rediff or hotmail ids.Just to be ensure that the postings are authentic.Thanks.
1722 Mar 2006 @ 01:15 PSTJobsReplylooking for job: advanced teradata certified professionalAppreciate if you can mention your work-id (outlook id) rather than yahoo or rediff or hotmail ids.Just to be ensure that the postings are authentic.Thanks.
1608 Mar 2006 @ 10:36 PSTDatabaseReplyHow to Use Input ParametersIt will stay there in the database where you create it, as long as you dont drop it.So, you do not need to recreate it. Hope that answers you.
1508 Mar 2006 @ 02:09 PSTDatabaseReplyDelete OperationTransient journalling had been in progress, so the rollback too will take a good time to complete.
1408 Mar 2006 @ 02:07 PSTDatabaseReplyHow to Use Input ParametersThis is the way to create.CREATE MACRO MYDATABASE.MYMACRO(PARAM1VAL INTEGER,PARAM2VAL INTEGER)as(SELECT Emp_NameFROM MyTableWHEREEmp_Number Between :param1Val and :param2Val;);To execute, just give...
1308 Mar 2006 @ 02:03 PSTDatabaseReplytimestamp to timestamp(0)This one will work for you : insert into destination ( dateA )select cast(cast(dateB as varchar(19)) as timestamp(0))from source
1224 Feb 2006 @ 08:02 PSTDatabaseReplynested case statementsYes, they are.Select case when "condition" then case when then ...This way, you can.
1122 Feb 2006 @ 06:08 PSTDatabaseReplyWhy the follwing query is getting lockedNot sure as to what is the question that you want to ask. Can you elaborate?