#DateForumTypeThreadPost
9607 Oct 2013 @ 09:28 PDTDatabaseReplyDelete last 35 days data from the table  Hi,   How about ...... qualify count(transdate) over (partition by transdate rows between unbounded preceding  and unbounded following) = 35 in your query limit. &n...
9507 Oct 2013 @ 08:57 PDTDatabaseReplyAnything similar to DENSE_RANK() in OracleHi, Teradata has rank function. All you need to do is tweak with a self  join and rank. I think Dieter has worked it out. Re-inventing the wheel????   http://developer.teradata.com/bl...
9407 Oct 2013 @ 02:37 PDTData ModelingTopicRow header Can anyone please let me know if there are cases where row header overhead for MVC  can increase or expand the capacity or size?   Thanks and regards, Raja
9307 Oct 2013 @ 02:06 PDTData ModelingReplyAvailability of Telecom Communication Data model documentation for RFP preparationHi Rita, It may be just like a prototype. It has subject areas like Event, Network,Network Activity,Finance, Finance mgmt,master, offering,promotion,Party. Under these SAs there are facets li...
9206 Oct 2013 @ 11:27 PDTDatabaseReplyHash Index and Single Table Join IndexHi Shantanu,   This is what I conceive:   Hash Index has subtable   Hash index and Single table join indexes can be row-compressed, value-ordered. I am not pretty sure...
9104 Oct 2013 @ 05:08 PDTDatabaseReplyHow to store columns values in TD stored procedure variable.Your description is big :). If you want to store and use values in stored procedure, you can do this way. Inside stored procedure, say you delcare a variable thus: Declare V_Counter Integer; &nb...
9004 Oct 2013 @ 04:21 PDTData ModelingTopicRow size ----columnar I am curious about the row header. I assume my understanding is right. The rowid is 128 bits. 64 bits internal partition number, 16 or 20 hash bucket and 16 or 12 bit remainder and 32 bit un...
8904 Oct 2013 @ 12:41 PDTGeneralReplyWhat role does last 16bit play in 32 bit ROW HASHI think it is the ist 16 or 20 bits of the rowhash tell us the bucket number, depending on the systems with 65,536 hash buckets or 1,048,576 hash buckets.
8803 Oct 2013 @ 11:23 PDTDatabaseReply3556 : Database does not have a permanent journalIf developer does not have the right to modify the database, then he must request the DBA. Conventionally, PJ comes along with a table that requests it. It is usually CREATE DATABASE xxxxx ..........
8703 Oct 2013 @ 11:02 PDTDatabaseReplyQuery with TOP and COUNTHi,   I think this is what you want.... SELECT location_Id , prodid , sales_amt ...... .....   FROM trans_fact WITH SUM(sales_amt) BY location_Id ORD...
8603 Oct 2013 @ 12:58 PDTGeneralReplyExporting around 3 TB of data from TeradataHi Amit, How about increasing to the maximum sessions? Also you can contact the DBA how he allocates the utilities(mload, fastload....) , session management. Thanks and regards, Raja
8503 Oct 2013 @ 12:18 PDTGeneralTopicR in-dabatase Analytics integrationHi, I am curious about the integration of R in-database analytics integration into Teradata with xml data types, geospatial data types, temporal ..  Does it mean that it is integrated to the ...
8401 Oct 2013 @ 01:08 PDTDatabaseTopicContent of dictionary CacheHi, I am interested to know the content of dictionary cache in the PE. Can anyone share with me?   Thanks and regards, Raja
8330 Sep 2013 @ 12:26 PDTDatabaseReplysnap to scd using sqlTo maintain scd and maintain history of changes, you need to identify what are the column(s) that are changing( It can be  the job). Say an employee changes his job from SE to SSE. You can kee...
8229 Sep 2013 @ 11:58 PDTData ModelingReplyDo we need an intelligent key for each subject areaHi Jake, I totally agree with you .I hope I can implement this if I have heteregenous sources to answer business questions in a proper way. But I will never use this for join :).   Thanks a...
8129 Sep 2013 @ 11:21 PDTDatabaseReplyTERADATA Architecture - parallelism?Parallel Database Extensions( PDE) is a software layer(interface) rich in sophisticated algorithms takes control of Teradata parallelism. It lies between the OS and Teradata server. Speed and linea...
8027 Sep 2013 @ 02:42 PDTData ModelingReplyWhat is a building block approach to building semantic data models?Hi, I always feel that creating physical tables will be creating duplicate data again. Using views makes more sense I feel. Say for example in a big organization where there are different departme...
7926 Sep 2013 @ 12:57 PDTData ModelingTopicMOLAP to ROLAPHi, I am planning to replace MOLAP with ROLAP using snowflake. I think I can use a PPI alongwith value order  in AJI for performance in TD 13.10. Should I  remove all foreign keys and...
7824 Sep 2013 @ 11:25 PDTData ModelingReplyHistory maintenanceHi Dieter, Thanks for the response. So I will not use bitemporal . Rather I will use Timestamp. I am just curious about this design I have in mind. I have SCD type 2 table. I know exposing views ...
7720 Sep 2013 @ 01:11 PDTDatabaseReplyShould I create staging tables with PI or shall I create NOPI tables?You have umpteen options with Teradata.   You can use NoPI staging tables. Probably you can download to a file. Then use fload to a staging NoPI table. Then load to a target table using ins...
7619 Sep 2013 @ 03:54 PDTDatabaseReplyChallenges in migrating from Informix to Teradata 13 Hi Anirban,   I think you are talking about Informix Dynamic.   When we migrate from one db to another, we make sure that the functionalities remain the same.  ...
7518 Sep 2013 @ 01:33 PDTData ModelingTopicHistory maintenanceHi, Which one will consume less space if I am to implement a centralized DWH ,( I am referrring to Historical data) if I am a designer 1) Implementing Dimensional model SCD or 2) Using VALIDTIME...
7416 Sep 2013 @ 11:48 PDTDatabaseReplySQL WorkaroundHi, Just my small cents :) Yes , I do agree a JI will hamper the insert performance. I see that a single table JI can help a little. How about partitioning a huge table? It is just my thought. ...
7313 Sep 2013 @ 04:24 PDTDatabaseTopicLoading nonpartitioned NoPI from a fileHi, I am planning to load a  nonpartitioned NoPI from an external  file using mload, fload and tpump. What are the hiccups I may face? Or is it better to stage first to a staging t...
7213 Sep 2013 @ 02:54 PDTDatabaseTopicFload into a nonpartitioned Nopi tableHi, May I know the reason why TD uses system amps and offline amps accessing the configuration map(also why using configuration map?) to load data into non-partitioned NoPI table? Thanks and rega...

Pages