#DateForumTypeThreadPost
2101 Sep 2015 @ 08:09 PDTToolsReplySQL Assistant "execute the query one statement at a time"To execute multiple statements you must put SQL Assistant in Teradata mode rather than ASCII mode.  Execute this command to put the Assistant in the right mode: .set session trans B...
2020 Feb 2015 @ 10:23 PSTDatabaseReplyOrder of executionjjj, You posted this question in the "Data Modeling" forum.  I think your target audience for this question in the forumn named "Database".
1917 Jun 2014 @ 11:47 PDTData ModelingReplyDatabase Design ToolDon't even try to build a data warehouse model without a real modeling tool.  There are many productivity features in a "real" modeling tool that a drawing tool cannot provide.&n...
1817 Dec 2013 @ 08:21 PSTData ModelingReplyErwin report template Raja, The choice of entity/attribute vs. table/column depends on the intended use of the report.  People working with the physical database will want the table/columns.  This would be th...
1707 Oct 2013 @ 08:37 PDTData ModelingReplyRow size ----columnarRaja, A question like this is more suited to the Database forum where performance questions are commonly answered.
1619 Sep 2013 @ 02:21 PDTData ModelingReplyDo we need an intelligent key for each subject areaRaja, I cannot offer any indisputable case for an intelligent key.  If a natural key is not suitable I would use a surrogate key.  However, a natural key might be also an intelligent key...
1509 Sep 2013 @ 01:44 PDTData ModelingReplyKimball methodology or Inmon methodology for SCD type 2 implementationRaja, I am not aware that Inmon has a methodology for SCD Type 2 dimensions.  That term was coined by Kimball and he has thoroughly expounded on it.  Are you referring to handling SCD Typ...
1409 Sep 2013 @ 12:49 PDTData ModelingReplyDo we need an intelligent key for each subject areaHi Raja, I going to risk an assumption and suppose that by "subject area" you mean each major subject of the model.  For example, in the Teradata Healthcare model we have 13 major su...
1306 Sep 2013 @ 11:58 PDTData ModelingReplyDo we need an intelligent key for each subject areaRaja, Help me understand your question before I attempt a response.  When you say "subject area" are you refering to a Teradata industry model subject?  If not, please explain.&...
1219 Aug 2013 @ 12:25 PDTData ModelingReplyModeling for NUPI and USI combinationUsing a USI to ensure uniqueness is not neccesarily the way to go.  Suppose your model has a PK specified that will give uniqueness, but your actual table has rows that are end dated so a new ...
1113 Aug 2013 @ 09:44 PDTData ModelingReplyDocumentsDAMA (Data Management International) is my prefered professional group for data modeling meetings.  http://www.dama.org/i4a/pages/index.cfm?pageid=1 TDWI is also good and has lots of educatio...
1013 Aug 2013 @ 09:41 PDTData ModelingReplyDocumentsHi, There are three basic styles of modeling of which I am aware.  You should choose to study the one most pertinent to your field of work: entity modeling, object modeling, data vault modeli...
915 Jul 2013 @ 03:02 PDTData ModelingReplyWhat is the purpose of Conceptual modellingThe purpose of a conceptual model is to provide a high level understanding of the entire model in a concise form that can be understood by business analysts and Subject Mater Experts (SME) in about...
812 Jun 2013 @ 09:44 PDTData ModelingReplyEffect of reversing the order of columns in mutli-column statsYou might get more responses in a forum on performance.  This forum is on data modeling.
710 Jun 2013 @ 03:04 PDTData ModelingTopicResources for modeling for SNOMED CTHere 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...
610 Jun 2013 @ 11:38 PDTData ModelingReplySecurity views in Semantic data modelling.Vishal, Yes.  The views are usually handled by the DBA.  A skilled data modeler with a good tool can generate the "core" level view DDL.  Perhaps a modeler could ...
506 Jun 2013 @ 01:42 PDTData ModelingReplySecurity views in Semantic data modelling.Vishal, The only topic I mentioned that is database version dependant is temporal features.  They are in v12 and 13.  The SMBB is not a database component.  It is a design patern th...
406 Jun 2013 @ 09:56 PDTData ModelingReplySecurity views in Semantic data modelling.In the "pyramid" analogy for semantic layer design, traditional Teradata methodology proposes a layer for security views.  The following comments are based on typical needs and not a...
304 Jun 2013 @ 02:51 PDTData ModelingTopicHow to design next-generation data modelsI read an article in Healthcare It News by Shahid Shah about Electronic Health Record (EHR) modeling.  Mr. Shah enumerated seven (7) design principles for next generation modeling.  Being...
204 Jun 2013 @ 08:11 PDTConnectivityReplyHealthcare X.12 interfaceHi Larry, I will respond in case you haven't found an answer by now... and to let you know I will be checking this site regularly for healthcare modeling questions.  Teradata does no...
102 Aug 2012 @ 11:45 PDTToolsReplyLDM Mapping Your option #1 sounds like a "fork lift".  That is a term used in Teradata Professional Services (PS) to describe a quick move off an old platform and on to a Teradata platform.&n...