#DateForumTypeThreadPost
7112 Sep 2013 @ 11:57 PDTDatabaseTopicNoPI hashing algorithmHi, It seems that for a NoPI table , a query id is submitted to a randomized hashing algorithm to produce a hash value comprising of hash bucket number and a remainder. This number is used to assi...
7010 Sep 2013 @ 04:01 PDTData ModelingReplyWhat is the purpose of Conceptual modellingHi , Conceptual model represents mostly the business needs. It is usually business questions list and matrix. It serves as input to  the Logical data model which is a business solution. Conce...
6910 Sep 2013 @ 03:08 PDTData ModelingReplyKimball methodology or Inmon methodology for SCD type 2 implementationHi Arnett, If data volume is quite high then performance is going to be an issue always , I mean views on top of 3 nf. JI also  engenders storage issue. Dependent datamart dimension again is ...
6810 Sep 2013 @ 02:42 PDTData ModelingReplyDo we need an intelligent key for each subject areaHi Arnett,   Yes I am referring to the subject areas of Teradata if there are areas where we need Intelligent key. Also, when I am referring to the intelligent key it is general. I know nat...
6703 Sep 2013 @ 02:27 PDTData ModelingTopicDo we need an intelligent key for each subject areaHi, Can anyone please suggest if I need an intelligent key for each subject area? What are the pros and cons of  implementing for each and every subject area?   Thanks and regards, Ra...
6603 Sep 2013 @ 01:34 PDTData ModelingTopicKimball methodology or Inmon methodology for SCD type 2 implementationHi, Can anyone let me know with justifications and steps which one to choose of two evils :). Kimball methodology or Inmon methodology  for SCD type 2 implementation.   How do we ...
6503 Sep 2013 @ 12:23 PDTDatabaseReplyVTT vs GTTHi Dieter,   In the TD document it is given. Also I see that it is justifiable since, GTT can be  shared across multiple users. So a lookup may be slightly more time-consuming than VT. ...
6402 Sep 2013 @ 12:29 PDTAnalyticsTopicPartial or full column(s) compressionHi, With technologies and requirements coming up, I feel there is a need to have databases or appliances where the entire column(s) can be compressed partially or fully. I see that Teradata and Gr...
6330 Aug 2013 @ 02:17 PDTDatabaseReplyVTT vs GTTYou can have a better performance with VTT compared with GTT. Thanks and regards, Raja
6223 Aug 2013 @ 12:10 PDTDatabaseReplyMigrating From Oracle To Teradata Help With DDL GenerationHi Saravanan, From my work experience of 6 years in Oracle and 7 years in Teradata, I feel that you can do it manually since client is constraining  you from tool overhead. In addition, doing...
6119 Aug 2013 @ 11:53 PDTDatabaseTopicFerret utilityHi, I know that Ferret utility automatically manages Teradata file system. It works on data levels as vproc,table, subtable,WAL log,disk and cylinder. We can run scandisk from supvr, define scope....
6029 Jul 2013 @ 03:00 PDTDatabaseTopicPacked64 Row FormatHi, Can someone cite me with example on Packed64 Row Format, where data fields  need not be aligned on 8-byte boundaries.   Thanks , Raja
5929 Jul 2013 @ 12:10 PDTDatabaseTopic8-byte partitioningHi, I have worked on partitioning before. I know the limits for  NoPI column-paritioned too but I am a bit confused about 2-byte partitioning and 8-byte partitioning and why 8 bytes for numbe...
5825 Jul 2013 @ 03:28 PDTDatabaseReplyCan I do select from fallback table?I am thinking from many  directions, say that if my amp is down and in recovery stage online, then without wasting time, I can can redirect my query to read from fallback or primary, my choice...
5724 Jul 2013 @ 02:52 PDTDatabaseTopicCan I do select from fallback table?Hi, I am curious if I can I do select from fallback table. Thanks and regards, Raja
5624 Jul 2013 @ 02:52 PDTDatabaseTopicCan I do select from fallback table?
5524 Jul 2013 @ 02:11 PDTDatabaseReplyUnicode vs LatinI know that it can be done but my question is something different. Thanks, Raja
5423 Jul 2013 @ 05:26 PDTDatabaseTopicUnicode vs LatinHi, I see that Teradata uses UNICODE for data dictionary tables or system tables and Latin for user data. May I know the reasons and advantages of doing this?   Thanks and regards, Raja
5322 Jul 2013 @ 06:44 PDTDatabaseTopicWrite ahead logHi, I know that WAL has redo records that need to be written to disks and has TJ recs . I am interested in the location,format and structure of its content. Can anyone please provide me the conten...
5222 Jul 2013 @ 02:31 PDTDatabaseTopicDatabase in quiescent state Hi,   Please help me in clarifying my doubts.   I think that Teradata system is in quiescent state, it means that no sessions are logged on(maybe users are able to logi...
5118 Jul 2013 @ 02:50 PDTData ModelingTopicModeling for NUPI and USI combinationHi, I think that for insert intensive I will use NUPI and USI combination. I am not using UPI. But the columns chosen for the UPI of a table are frequently the same columns identified as the PK du...
5017 Jul 2013 @ 11:31 PDTDatabaseReplyDifference between Application RI,Batch RI,explicit & standard RI?Hard RI is when we implement references ( say emp vs dept tables) where deptno is referenced in emp table to dept table explicitly. However, when we comment the code in DDL about this same referenc...
4917 Jul 2013 @ 04:24 PDTGeneralReplyinterview helpPlease mail to my id: ktraj1@gmail.com
4817 Jul 2013 @ 02:21 PDTDatabaseTopicCan someone plz elaborate with example on byte-packed format rather than byte-aligned formatHi,   Can someone plz elaborate with example on byte-packed format rather than byte-aligned format.   Thanks and regards, Raja
4712 Jul 2013 @ 05:04 PDTDatabaseReplyInformation about Inverted list databaseHi Dieter, I just  to know about the features of Inverted list. I guess it is a database. I am seeing that set processing can have more chances of lock contention than a row processing. Plea...

Pages