All forum activity

#DateUserForumTypeThreadPost
74213 Apr 2006 @ 03:53 PDTdwuser123ToolsTopicHow to convert an ER Model to a Star Schema? (Practical test...Hello Friends,For people involved with Data warehousing, this is one of the MOST TYPICAL Questions they face . ie how to convert a BIG 3rd Normalized ER Diagram into a Simple Star Schema (Dimension...
74113 Apr 2006 @ 03:50 PDTdwuser123DatabaseTopicHow to convert an ER Model to a Star Schema? (Practical Approach)Hello Friends,For people involved with Data warehousing, this is one of the MOST TYPICAL Questions they face . ie how to convert a BIG 3rd Normalized ER Diagram into a Simple Star Schema (Dimension...
74013 Apr 2006 @ 03:48 PDTdwuser123UDATopicHow to convert an ER Model to a Star Schema? (Practical tested Approach)Hello Friends,For people involved with Data warehousing, this is one of the MOST TYPICAL Questions they face . ie how to convert a BIG 3rd Normalized ER Diagram into a Simple Star Schema (Dimension...
73912 Apr 2006 @ 11:28 PDTyoungDatabaseTopicquestion on TD partition, need help!If the partitioning columns are not part of the Primary Index, the Primary Index cannot be unique (e.g., Location_Number). To maintain uniqueness on the Primary Index, we can create a USI on the PI...
73812 Apr 2006 @ 11:25 PDTyoungDatabaseReplyRandomied sampletry to define value range of ASR, and then sample the records within one specific value range, you need to define the sample number of different range to make it close to avg value.
73712 Apr 2006 @ 10:34 PDTMusomasuToolsReplyHelp required BTEQ IMPORTHi Deiter Thanks for the Help,it works fine.thanks
73612 Apr 2006 @ 08:40 PDTKksTrainingReplyIs Teradata Certified Professional V2R6 (NR0-011) available to be taken?Hi,BTW r u V2R5 Certified
73512 Apr 2006 @ 08:39 PDTKksTrainingReplyPreparation for Teradata Certification ExamHi,There is a interesting thread 'Teradata Basic Certification' you will find the answers,Teradata is the easiest platform to learn
73412 Apr 2006 @ 12:14 PDTdnoethToolsReplyHelp required BTEQ IMPORTHi Musomasujust use a multistatement:.LOGON demotdat/dbc,123;.import vartext file=params.txt;using eno(varchar(1)) sel * from abc.emp where emp_no=:eno;using eno(varchar(1)) sel * from abc.manager ...
73312 Apr 2006 @ 11:24 PDTMusomasuToolsReplyHelp required BTEQ IMPORTHi i Tried with vartext and worked fine.params.txt1script..LOGON demotdat/dbc,123;.import vartext file=params.txt;using eno(varchar(1)) sel * from abc.emp where emp_no=:eno;.LOGOFF;.QUIT;can we use...
73212 Apr 2006 @ 10:02 PDTCraig.SchweizerDatabaseTopicWrite/Read external file from within Stored Procedure?Is there a way to read and/or write to an external file from within a Stored Procedure. I have a requirement that after performing some processing logic to write the clean records to an extract fi...
73111 Apr 2006 @ 06:56 PDTmembryJobsTopicETL developer position in the Dallas areaI'm looking for an ETL developer with 3 - 6 years experience using the Teradata utilities and any experience with Informatica, Ascential or Sunopsis. I'm interested in either permanent or contract....
73011 Apr 2006 @ 02:28 PDTdharmaDatabaseTopicRandomied sampleCan someone please helpI have a table with account_numberfirst namelast namepresent balanceoutstanding balanceASRThis table has lets say 2 million records.i have to take a sample from this table fo...
72911 Apr 2006 @ 02:09 PDTshaik.feroz@aaa-calif.comUDAReplyMload delimited file with delimiter embedded in fieldMike,If the file is not huge I would do the follwing stepsif you are on a unix env.assume the delimiter is comma , and all the actual text commas are specified as ","replace all the "," s with a ch...
72811 Apr 2006 @ 01:02 PDTdnoethTrainingReplyHow many Certified Teradata MastersSorry not to be clear:750Dieter
72711 Apr 2006 @ 11:22 PDTdharmaAnalyticsTopicRandomied sampleCan someone please helpI have a table with account_numberfirst namelast namepresent balanceoutstanding balanceASRThis table has lets say 2 million records.i have to take a sample from this table fo...
72611 Apr 2006 @ 09:09 PDTTDUser-781ToolsReplyHelp required BTEQ IMPORTHi Musomasu,try defining fornmat for you input file....if I were you I would define format vartext and declare eno variable as VARCHAR(1).Hope this helps,Bye,TDUser
72511 Apr 2006 @ 08:38 PDTMusomasuToolsTopicHelp required BTEQ IMPORTHi i am trying to import a file using BTEQ here are the file details and script. when i try to import it is giving error.params.txt1script..LOGON demotdat/dbc,123;.import data file=params.txt;usin...
72411 Apr 2006 @ 05:14 PDTMikeAUDATopicMload delimited file with delimiter embedded in fieldHiTrying to load a (tab) delimited file into Teradata (V2R5) using Mload. The supplier of the file has stated that any character may appear in the text fields, including the delimiter. In this case...
72311 Apr 2006 @ 04:07 PDTdwuser123DatabaseTopicStar Schema Design + Performance TipsHello Friends,You can download an IBM Book on Dimensional Modeling from the following link:http://www.redbooks.ibm.com/abstracts/sg247138.html?OpenThis is an excellent IBM Redbook on Data warehouse...
72210 Apr 2006 @ 10:35 PDTmachikereAnalyticsTopic3706: Syntax error: expected something between ')' and '='.Hi:I know this question is alfready asked , but any help in resolving this issues is appreciated.Iam trying to run the following query & geeting the error:select count(pr_id) as keycount, pr_id, ...
72110 Apr 2006 @ 06:55 PDTshaik.feroz@aaa-calif.comDatabaseReplyweird issue importing from excel to TD.....I guess the delimeter that is used as default in your import/export option is set to something other than comma.In queryman check this (click on the follwing menu option)Tools -> Options -> Export ...
72010 Apr 2006 @ 06:28 PDTKksTrainingTopicTeradata Master Certificate , How worthy it isHello all,Please share your experience if you are Teradata Master How much worth did you found of it
71910 Apr 2006 @ 06:24 PDTKksTrainingReplyHow many Certified Teradata MastersHi Dnoeth,your 750... meant 750 only or 750xxx
71810 Apr 2006 @ 12:29 PDTdwuser123ToolsTopicDownload Dimensional Modeling (star schema) BookHello Friends,You can download an IBM Book on Dimensional Modeling from the following link:http://www.redbooks.ibm.com/abstracts/sg247138.html?OpenThis is an excellent IBM Redbook on Data warehouse...

Pages