All Forums

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

You must login to post to the forums.
Nested Update - Case issue Topic by danimaltex 22 Oct 2014

Hi all - 
I am looking for some input on an UPDATE statement. I am still new to Teradata and looking to do an update based on certain conditions.. Below is the statement i have right now..Please let me know if i have left anything out... I'm not sure if it would be better to split this up or use this type of case statement..

2386 views
1 reply, 6 years ago
special characters such as '¬', crtl B, crtl A etc from sybase to TD Topic by palakpatel 20 Oct 2014 special character control b, control a etc

Hello,
 
recently i been assinged a major Migration project in my recent company. so there are bunch of existing & working sybase code/jobs i am converting to TD one by one. I came across with one challenging code where we are concnating 2 strings and in btween them we are adding '¬'/crtl B. for same results, we are using XXXX+char(2)+YYYY in sybase. 
 

1717 views
1 reply, 7 years ago
Partitioning on a flag (column) Topic by danimaltex 17 Oct 2014

Hi all!

1611 views
1 reply, 7 years ago
Any New School of Thought to Optimize Multi-TB Data Mart Analytics? Topic by dgarg80 12 Aug 2014 data marts, modelling, performance, normalization, dimesnion

Typical 2 years Sales Data Mart contains detail and aggregates in order to support time traverse metrics like 4 Week Shipments, 13 Week Shipments and so on... 

1276 views
1 reply, 7 years ago
Optimized Sales Mart Data Structures- New School of Thought Topic by dgarg80 07 Aug 2014 Data Mart, sales, analytics, Optimized Data Mart Structures

Typical 2 years Sales Data Mart contains detail and aggregates in order to support time traverse metrics like 4 Week Shipments, 13 Week Shipments and so on...

1175 views
0 replies
Database Design Tool Topic by andydoorey 16 Jun 2014 data modelling, ERD, tools

Is anyone using, or have any suggestions for, a free/cheap data modelling or database design tool?  We are about to start planning and building a new data warehouse.  It is fairly small, and we can't justify paying for Erwin licences, so I wondered if anyone was using anything else.

1861 views
4 replies, 7 years ago
FS-LDM - how does it ship? Topic by amorts 14 Jul 2014

We have recently purchased the FS-LDM along with a new Teradata appliance. We have been informed that this ships with the appliance.
My understanding is the FS-LDM is simply a data model file which can be viewed or edited in Erwin for example, is this correct?

1212 views
0 replies
What is a building block approach to building semantic data models? Topic by egetts 02 Dec 2011

The idea is that modeling constructs could be pre-defined and developed to promote rapid time to value, design flexibility, data consistency, and user-friendliness. These building blocks could be collected into libraries, customized, and reused.

25578 views
15 replies, 7 years ago
Creating a table of a given size filled with random numbers Topic by alscor 11 Jun 2014 random numbers

How to generate a table of a given size (say, 1 million rows) with a column that represent a random number?
I need to create a table, which will have two columns: row_num, rand_num:
Row_num rand_num
             1           23
             2             3
             3           12
             4           89
             5            …

1730 views
3 replies, 7 years ago
Accessing Information from Visio ERD Topic by andydoorey 12 Jun 2014 visio, ERD

I'm just looking at using Visio 2010 to create a database design.  The tools seems a great way of entering information and drawing the ERD.  However there doesn't seem to be any way of getting the data out again after you have put it all in.

1496 views
0 replies
Bridge tables Topic by mukejee 20 May 2014

Hi Experts,
Is there any limit in the number of bridge tables in a data model.
I am having a scenario where we store accident details in a table. One accident is associated with many behaviour types and 1 behaviour type will affect many people.
its like accident1 --> behaviour1, behaviour2
                               behaviour1 --> person1, person 2

1226 views
2 replies, 7 years ago
Using a PPI column in PI Topic by aarsh.dave 20 Jan 2014 pi, ppi, data modeling, skew

Hi All,
I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI.
As per the current data, the table has a skew factor of 75%.
Therefore, I created an identical table, this time with PI consisting of Col_A, Col_B and Col_C, with Col_C again as PPI.

1528 views
4 replies, 7 years ago
Understanding on Data modeling concepts Topic by kannan.muthu 05 Nov 2013

Being a beinner, wanted to learn on Data Modeling w.r.t Teradata. 
what are the appropriate materials?
Thanks
-Kannan.M

2267 views
4 replies, 7 years ago
Novice seeking help for teradata EDW modelling Topic by madasameee 24 Mar 2014 data modelling, data warehouse, terdata, edw, Active EDW, Novice, basics, teradata for beginners

Hi Everyone,
Good that i got this forum on the second day of my learning itself, not so late!! I have been with Oracle DWH, Informatica, Obiee and siebel for around five years and now seeking a change to Teradata EDW Modelling

1376 views
3 replies, 7 years ago
Converting Rows to Columns Topic by lbrec 24 Mar 2013

We have one business requirment where they want to convert rows to columns. The data we are talking about is 2-3 TB of data. Data looks something in this format.
Table Structure
Date_1                             Unit_Number   Data_ID  Data_Value
2013-01-02 00:00:00      100013           123          671

8890 views
6 replies, 7 years ago
ERwin vs PowerDesigner Topic by JeremyJ 19 Feb 2014

I'm looking at potential data modelling tools for our BI team and was wondering what experiences people have had using ERwin and/or PowerDesigner, both in general and specifically within a Teradata environment? Anything regarding pros and cons would be much appreciated, but if anyone has used both and can give me relative strengths and weaknesses that would be even better.

2431 views
2 replies, 7 years ago
Financial.... LDM Topic by Raja_KT 14 Nov 2013

Hi,
Are there any upgrade to Teradata Fsldm recently? The last one I saw was having these SAs:
Party, Party Assest, Agreement, Product, Event, Campaign, Channel,Location, Orgainzation,Finance Mgmt.
 
Thanks and regards,
Raja

3242 views
6 replies, 7 years ago
Lineage Topic by Raja_KT 11 Dec 2013

Hi,

Can someone share some thoughts on lineage tools for enterprise like BRE say? Previously I modeled meta independent of any tool. But in case someone has better experience, they can share, to trace the flow.

 

Thanks and regards,

Raja

1433 views
1 reply, 7 years ago
Using a PPI column in PI Topic by aarsh.dave 20 Jan 2014 pi, ppi, data modeling, skew

Hi All,
I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI.
As per the current data, the table has a skew factor of 75%.
Therefore, I created an identical table, this time with PI consisting of Col_A, Col_B and Col_C, with Col_C again as PPI.

1350 views
2 replies, 7 years ago
Mini Cylpack vs Cylinder migration Topic by M.Saeed Khurram 03 Dec 2013 Mini Cylpack, Cylinder Migration

Hi,
Can anybody please elaborate a clear difference of Mini Cylpack and Cylinder Migration? I am confused about these two concepts :(
 

1563 views
2 replies, 7 years ago
Erwin report template Topic by Raja_KT 17 Dec 2013

Hi,

I am not sure which one to run in erwin: CSV Entity names or CSV Tablename? They look to be the same?

Under what circumstances, we may have different reports?

Same thing happens with attribute and column names.

 

Thanks and regards,

Raja

1449 views
3 replies, 7 years ago
Delete Partition Vs Drop Partition? Topic by M.Saeed Khurram 03 Dec 2013 delete partition, drop partition

I have not done much work with partitions in Teradata, I just wanted to know the diffrence between Deleting a partition and sroping a partition? 
and what are limitations with these commands? 
 

3817 views
3 replies, 7 years ago
Nemo Q Topic by hsottil 22 Nov 2012

Hi.
Does anybody know if there is anywhere or subject area in the FS-LDM where I can find something about nemoQ or attention queues?
 
thanks in advance

3346 views
1 reply, 7 years ago
PPI VS NPPI Topic by M.Saeed Khurram 30 Nov 2013 PPI vs NPPI

hi,
When we partition a table based on PI it is called PPI, and if a table is not partitioned on PI, then it is called NPPI, my question is that is there any specific terminology about a table partitioned on non PI columns? Or we will simply call it PPI?

1982 views
5 replies, 7 years ago
Party Topic by Raja_KT 15 Nov 2013

Hi,
I think with this attribute "Party Related Role Cd" in Financial LDM, I can maintain the hierarchy in all entities. Can you please let me know the pros and cons?
Thanks and regards,
Raja

1428 views
0 replies

Pages