All forum activity

#DateUserForumTypeThreadPost
116721 Jun 2006 @ 02:46 PDTshaik.feroz@aaa-calif.comAnalyticsTopicproblem using Informatica to load Teradata tables.I have an issue while loading data from sql server to Teradata database. It takes a very long time to load 100K rows. when i checked the log I guess it is doing a row level insert instead of a bulk...
116621 Jun 2006 @ 12:50 PDTMikeToolsTopiclooping through a macro?Hi All,I've created a small macro that I want to loop through increasing the invalue parameter (it is an integer) by one every time I loop through the macro. Is this possible in TeraData?Please let...
116521 Jun 2006 @ 10:08 PDTTDUser-781DatabaseReplycommand to see description of column in teradataHi, you can retrieve:1. column list using "help table " syntax2. DDL of your table using "show table " syntaxHope this helps,Bye,TDUser
116421 Jun 2006 @ 09:42 PDTaneelDatabaseTopiccommand to see description of column in teradataheloo firends ,i am new to teradata database .how to find desciption of the table likeDESC in oracle in Teradata
116321 Jun 2006 @ 08:58 PDTBBR2ToolsReplyRights and UsersIf you are DBA, you can query DBC.Users (or DBC.Databases where dbkind = 'U')You may also want to use DBC.AllRoleRights instead of DBC.UserRoleRights.If the grants are direct (w/out using roles), y...
116220 Jun 2006 @ 07:15 PDTMikeDatabaseTopicLoop through a Macro?Hi All,I've created a small macro that I want to loop through increasing the invalue parameter (it is an integer) by one every time I loop through the macro. Is this possible in TeraData?Please le...
116120 Jun 2006 @ 01:41 PDTTeradata LearnerUDATopicadvantages of teradata over other databasesi want to know the advantages of teradata over other databases . And also disadvantages,(why 1 organisation should go for teradata and why not?)
116020 Jun 2006 @ 09:31 PDTsomaTrainingReplyNR-011 CertificationHi,Can you please tell me how to prepare means1. Books / links / pdfs where can i get2. links where i can pratice tests more before giving examThanksSoma
115920 Jun 2006 @ 06:51 PDTmorphikToolsReplyRights and UsersHi!If you want to collect information about all users and their rights, you can simply use DBC.UserRights view. To get an answer to your second question, try to join other two DBC views: RoleMember...
115820 Jun 2006 @ 06:22 PDTTD_ArchDatabaseReplyQueue 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, ...
115720 Jun 2006 @ 06:11 PDTTD_ArchDatabaseTopicQueue 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...
115619 Jun 2006 @ 09:35 PDTPhaniDatabaseReplyMigrating to V2R6My suggestion is to check with other applications used in your environment are compatible with TTU 8.0 before migrating. Compatability in terms of getting support from the respective vendors.
115519 Jun 2006 @ 09:33 PDTPhaniDatabaseReplyCOLLECT STATISTICSI recommend collecting stats on at least on Primary Index column. In the absence of stats, we may encounter soome bad plans. At times, a larg table may be assumed smaller to a small table. This lea...
115419 Jun 2006 @ 09:30 PDTPhaniDatabaseReplyPPI explainIn the second query, we have conditions on exactly primary index and partition columns. With additional ANDed conditions in the first query it picked up a different plan.
115319 Jun 2006 @ 09:24 PDTPhaniDatabaseReply10065 WSA E HostUnreachCould you check the pdestate with option a like pdestate -aIf you see something like logons are disabled, you need to enable the logons. Otherwise, you can not login.
115219 Jun 2006 @ 09:15 PDTPhaniAnalyticsReplyPERFORMANCE ISSUESThe statements SEL * FROM TABLENAME and SEL * FROM TABLENAME WHERE 1=1 have all rows scan access path. The performance difference is none. If you consider the following scenario,INS Target SEL * FR...
115119 Jun 2006 @ 08:32 PDTBBR2UDAReplyperformance issueI don't think there is any performace benefit doing this as in both cases we are not exploiting indexing strategy.Multistatements are good as they will be sent to database as a block.insert into .....
115019 Jun 2006 @ 04:52 PDTdnoethDatabaseReplyCollecting Statistics on multiple ColumnsHi stami27,there's no difference, if you collect stats on (col1, col2) or (col2, col1), because both stats are calculated exactly the same. Simple try it and then use a help stats:The order is defi...
114919 Jun 2006 @ 03:49 PDTTechnology RecruiterJobsTopicSenior Distributed Database Engineer (Teradata) -- Direct Hire Opportunity in New York CitySenior Distributed Database Engineer (Teradata)New York, NY -- Reputable, Financial Institution.This position requires a senior level, hands-on database engineer. The ideal candidate will have a d...
114819 Jun 2006 @ 12:46 PDTBBR2DatabaseReplyCollecting Statistics on multiple ColumnsIt may be important for covered indexes.For normal columns, i am not that sure.Vinay
114717 Jun 2006 @ 01:39 PDTstami27-2406DatabaseReplyCollecting Statistics on multiple ColumnsHi PhanyThanks for the reply.Does exist a place in the teradata documentation, where it is mentioned?greetings stami
114616 Jun 2006 @ 03:30 PDTPhaniDatabaseReplyCollecting Statistics on multiple ColumnsI do not think it makes any difference. When different column combinations are analyzed, the combined stats are analyzed. Based on this analysis, optimizer estimates the combined cost.
114516 Jun 2006 @ 03:27 PDTPhaniDatabaseReplywhy this error was raised? help me!According to ANSI semantics, we can not update the same target row by multiple source rows. This error is to prevent that.
114416 Jun 2006 @ 11:38 PDTBBR2DatabaseReplySecondary Index usageYou may know this just an FYIUse Index Wizard for recommendations on existing workload or a new SQL.Vinay
114316 Jun 2006 @ 09:56 PDTjat_kkpAnalyticsTopicComparing Date with Decimal ColumnGurus, I have a scenario where I need to figure out if the given data falls between the two dates.These two dates are two columns in which are datatype as Decimal(6,0).So my query according ...

Pages