All Forums

Discussion topics on Logical Data Models, Physical Data Models, and Semantic Modeling Building Blocks.

You must login to post to the forums.
PPI table having a column for same PI and SI Topic by Raja_KT 04 Nov 2013

Hi,

 

Please suggest this design if I define PI and USI for the same column. My date range partition for now.

 

Thanks and regards,

Raja

2857 views
8 replies, 7 years ago
Sliding/Single Window Merge Join Topic by Raja_KT 29 Oct 2013

Hi,
May I know the corrective measures(modeling or technical solutions) for sliding/single Window Merge Join when there are many noneliminated combined partitions.
Thanks and regards,
Raja

1489 views
0 replies
rowkey vs hash-based Topic by Raja_KT 25 Oct 2013

Hi,
I am at a loss for designing to choose, whether I should go for rowkey ....ie hash-based by partition or should I leave only hash-based. The reason, is that partition is taking extra 2 bytes. Query run

is a join of two tables and date partition is there besides PI. Or is there any better design?

 

Thanks and regards,

Raja

1563 views
0 replies
Join index Topic by Raja_KT 25 Oct 2013

Hi,
 
I have 3 qs:
 

1) Can we have JI for queries having subqueries?

 

 

2) Created JI on two tables joining a PI and non-PI and found that group amp is not used.I resorted to creating HI to solve the issue. However, I am in two minds, should I change an index totally for the 

second table or should I live with this HI?

 

1383 views
0 replies
Row header Topic by Raja_KT 07 Oct 2013

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

1790 views
2 replies, 8 years ago
RDBMS vs network vs hierarchical Topic by Raja_KT 08 Oct 2013

Hi,
I am at a loss for this simple question?
Is RDBMS technology-driven,business-driven,enterprise-driven or system-driven?
Any help with reference to reliable source or document or book is appreciated.
Thanks and regards,
Raja

1439 views
0 replies
Row size ----columnar Topic by Raja_KT 04 Oct 2013

I am curious about the row header. I assume my understanding is right. The rowid is 128 bits.

1476 views
1 reply, 8 years ago
Availability of Telecom Communication Data model documentation for RFP preparation Topic by ritabrata_saha 01 Oct 2013

Hello, I am in need for the "Teradata Communication Data Model" documentation so that it can be proposed as a part of the Request for Proposal along with the appliance. Model overview doc available over the internet is not sufficient.

1745 views
2 replies, 8 years ago
Do we need an intelligent key for each subject area Topic by Raja_KT 03 Sep 2013

Hi,
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,
Raja

2504 views
6 replies, 8 years ago
Data Modeling Online Training Call Us +919000444287 Topic by 21cssindia1 29 Sep 2013 Data Modeling Online Training

Data Modeling Online Training

Click Here For Enquiry

Chapter 1: Data Modeling Concepts

1757 views
0 replies
MOLAP to ROLAP Topic by Raja_KT 26 Sep 2013

Hi,

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 primary keys to tables replacing  with unique constraint or UPI and not null?

 

1315 views
0 replies
History maintenance Topic by Raja_KT 18 Sep 2013

Hi,
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 and TRANSACTIONTIME, bitemporal feature inTeradata?
Please share your thougts.
Thanks and regards,
Raja

1919 views
3 replies, 8 years ago
Modeling for NUPI and USI combination Topic by Raja_KT 18 Jul 2013

Hi,
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 during the data modeling process. Can you please suggest me?
 
Thanks and regards,
Raja

2124 views
4 replies, 8 years ago
What is the purpose of Conceptual modelling Topic by learnconcepts 02 Jul 2013

I can see physical and conceptual modelling as same. Whatever we need for conceptual modelling will be present in physical modelling.
 
Please explain what is the purpose of conceptual modelling?

3544 views
2 replies, 8 years ago
Kimball methodology or Inmon methodology for SCD type 2 implementation Topic by Raja_KT 03 Sep 2013

Hi,
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 handle in case of Inmon method or in Teradata, since I can see that a semantic layer sits on top of 3NF.
Thanks and regards,
Raja

3100 views
2 replies, 8 years ago
Documents Topic by vinaykumar49 18 Jul 2013

Hi,
I am very much interested to learn and implement Data Modeling. Does any one have very document that can be easily understood
 
 

2157 views
2 replies, 8 years ago
Effect of reversing the order of columns in mutli-column stats Topic by terasum 12 Jun 2013

Does it make a difference if we reverse the order of the columns mentioned in multi-column stats.
Eg:- collect stats on emp column (a,b)  Vs  collect stats on emp column (b,a)
 
Cheers :-)
SK

2114 views
4 replies, 8 years ago
Security views in Semantic data modelling. Topic by Vishal1 06 Jun 2013

Hi,
In semantic data modelling there is layer called as Security Views and I was trying to understand how to apply Row level and Column level security in Security views.
Is this security means a user profile level which can be handled by DBA's OR something else which developer can handle it in views by writing some statements while developing views.

3472 views
6 replies, 8 years ago
Resources for modeling for SNOMED CT Topic by HCDM 10 Jun 2013 SNOMED Healthcare HC-LDM Modeling

Here are links to two very good technical resources for SNOMED CT.  I referenced them extensively when modeling SNOMED in the Teradata Healthcare data model (HC-LDM.)
Technical Implementation Guide for RF2

1698 views
0 replies
How to design next-generation data models Topic by HCDM 04 Jun 2013 modeling healthcare HC-LDM design principles

I read an article in Healthcare It News by Shahid Shah about Electronic Health Record (EHR) modeling.  Mr.

2952 views
0 replies
data conversion Topic by mensssanvi 02 May 2013

This field Resid_Mat is rounding to to 2 decimal places, thus having an effect on the Num_payment field calculation as per attached sql. Does anyone know how I can remedy this? Any help will be much appreciated.

An example of Resid_Mat by running the sql gives me 2.32 instead of 2.31895961670089.

 

--------------

1634 views
1 reply, 8 years ago
cursor Topic by mensssanvi 08 May 2013

I'm trying to create a cursor with the following statement but not sure from where to start. Please help!

1494 views
0 replies
vba to teradata sql Topic by mensssanvi 25 Apr 2013

Hi all, I'm sort of new to this site so forgive me if my posting doesn't make any sense -:). anyway, is there anyone out there that can help me replicate the below VBA code into teradata SQL? Thanks in advance
--------------

1581 views
0 replies
Conversion of numeric to date and group by it. Topic by wicik 19 Mar 2013 sql, numeric to date, decimal to date

Hi there...
I'm pretty nobbish in this type of SQL so please try not to be rough for me :)
 
Well.. I have to convert numeric field to date, than count some upload data and group by table.
Numeric_column like 20121121133549 which is probably like YYYYMMDDHHMMSS
Other columns are acces_point_type and data_uplink.

2182 views
1 reply, 8 years ago
ER model and dimensional model Topic by TD_DEV245 18 Sep 2012 dimensional model, data modelling, third normal form, kimball, inmon

Hi,
  1.Please explain the difference between ER model and dimensional model in a simple manner
 2.Is it necessary that tables present in both ER model and Dimensional model should be in third normal form
3.Is Enterprise Datawarehouse(EDW) constructed using ER model?
4.Is Datamart constructed using Dimension model?

11399 views
4 replies, 8 years ago

Pages