742 | 13 Apr 2006 @ 03:53 PDT | dwuser123 | Tools | Topic | How 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... |
741 | 13 Apr 2006 @ 03:50 PDT | dwuser123 | Database | Topic | How 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... |
740 | 13 Apr 2006 @ 03:48 PDT | dwuser123 | UDA | Topic | How 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... |
739 | 12 Apr 2006 @ 11:28 PDT | young | Database | Topic | question 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... |
738 | 12 Apr 2006 @ 11:25 PDT | young | Database | Reply | Randomied sample | try 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. |
737 | 12 Apr 2006 @ 10:34 PDT | Musomasu | Tools | Reply | Help required BTEQ IMPORT | Hi Deiter Thanks for the Help,it works fine.thanks |
736 | 12 Apr 2006 @ 08:40 PDT | Kks | Training | Reply | Is Teradata Certified Professional V2R6 (NR0-011) available to be taken? | Hi,BTW r u V2R5 Certified |
735 | 12 Apr 2006 @ 08:39 PDT | Kks | Training | Reply | Preparation for Teradata Certification Exam | Hi,There is a interesting thread 'Teradata Basic Certification' you will find the answers,Teradata is the easiest platform to learn |
734 | 12 Apr 2006 @ 12:14 PDT | dnoeth | Tools | Reply | Help required BTEQ IMPORT | Hi 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 ... |
733 | 12 Apr 2006 @ 11:24 PDT | Musomasu | Tools | Reply | Help required BTEQ IMPORT | Hi 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... |
732 | 12 Apr 2006 @ 10:02 PDT | Craig.Schweizer | Database | Topic | Write/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... |
731 | 11 Apr 2006 @ 06:56 PDT | membry | Jobs | Topic | ETL developer position in the Dallas area | I'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.... |
730 | 11 Apr 2006 @ 02:28 PDT | dharma | Database | Topic | Randomied sample | Can 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... |
729 | 11 Apr 2006 @ 02:09 PDT | shaik.feroz@aaa-calif.com | UDA | Reply | Mload delimited file with delimiter embedded in field | Mike,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... |
728 | 11 Apr 2006 @ 01:02 PDT | dnoeth | Training | Reply | How many Certified Teradata Masters | Sorry not to be clear:750Dieter |
727 | 11 Apr 2006 @ 11:22 PDT | dharma | Analytics | Topic | Randomied sample | Can 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... |
726 | 11 Apr 2006 @ 09:09 PDT | TDUser-781 | Tools | Reply | Help required BTEQ IMPORT | Hi 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 |
725 | 11 Apr 2006 @ 08:38 PDT | Musomasu | Tools | Topic | Help required BTEQ IMPORT | Hi 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... |
724 | 11 Apr 2006 @ 05:14 PDT | MikeA | UDA | Topic | Mload delimited file with delimiter embedded in field | HiTrying 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... |
723 | 11 Apr 2006 @ 04:07 PDT | dwuser123 | Database | Topic | Star Schema Design + Performance Tips | Hello 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... |
722 | 10 Apr 2006 @ 10:35 PDT | machikere | Analytics | Topic | 3706: 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, ... |
721 | 10 Apr 2006 @ 06:55 PDT | shaik.feroz@aaa-calif.com | Database | Reply | weird 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 ... |
720 | 10 Apr 2006 @ 06:28 PDT | Kks | Training | Topic | Teradata Master Certificate , How worthy it is | Hello all,Please share your experience if you are Teradata Master How much worth did you found of it |
719 | 10 Apr 2006 @ 06:24 PDT | Kks | Training | Reply | How many Certified Teradata Masters | Hi Dnoeth,your 750... meant 750 only or 750xxx |
718 | 10 Apr 2006 @ 12:29 PDT | dwuser123 | Tools | Topic | Download Dimensional Modeling (star schema) Book | Hello 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... |