717 | 10 Apr 2006 @ 12:28 PDT | dwuser123 | Database | 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... |
716 | 10 Apr 2006 @ 12:12 PDT | Mike | Database | Topic | weird issue importing from excel to TD..... | Hi All,I am encountering an issue trying while I am trying to Import data from Excel to a TD table that is driving me a bit nutty. I keep getting the 'Wrong number of data values in Import file' e... |
715 | 10 Apr 2006 @ 12:06 PDT | gg | Tools | Reply | Tpump - Is blocking normal? | If the table write lock is the only problem remaining you may want to rearrange your batch window. If you have to load and query at the same time. You can give users access to that table via views ... |
714 | 10 Apr 2006 @ 01:50 PDT | young | Database | Reply | Identity Column Not Coming in a sequence. Need Suggestion. | The Teradata RDBMS does not have a direct SQL function to implement System-Assigned Keys. With Teradata V2R5, the SQL Identity feature can be used to “generate a table-level unique primary indexâ... |
713 | 09 Apr 2006 @ 04:47 PDT | dwuser123 | UDA | Topic | Download Great IBM 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... |
712 | 08 Apr 2006 @ 04:42 PDT | dnoeth | Training | Reply | How many Certified Teradata Masters | Hi Job_Agent,during last year's Partners the official count was announced to be about 750...Dieter |
711 | 07 Apr 2006 @ 09:53 PDT | redshark | Analytics | Topic | Updating a table from an imported file | Is there a way to update an existing Teradata table with data imported using the "Import Data from File" option?I have been able to Insert records using this approach to add new records to the tabl... |
710 | 06 Apr 2006 @ 08:22 PDT | Kks | Training | Reply | How many Certified Teradata Masters | Now there are many Masters , infact you cannot count, from Beijing to toronto thousands of them . |
709 | 06 Apr 2006 @ 07:19 PDT | TechSmarts | Jobs | Topic | Teradata DBAs : Omaha, NE | I need a Teradata DBA for a contract position for 1 year in Omaha, NebraskaThe position will include new development and supporting current applications in a Unix/Teradata environment. This person ... |
708 | 06 Apr 2006 @ 02:33 PDT | nudoam | Tools | Reply | Tpump - Is blocking normal? | I tried the serialize option and we still get numerous blocks.Some processes we can drop indexes, mload, and recreate indexes.However, the process I'm testing is an extremely large table and to dro... |
707 | 06 Apr 2006 @ 02:12 PDT | shaik.feroz@aaa-calif.com | Tools | Reply | Tpump - Is blocking normal? | This is a good way to do:alternative way to load the data:1. fastload file into empty staging table2. insert select via btequse the same PI for staging and destination tableand we did the following... |
706 | 06 Apr 2006 @ 12:51 PDT | Natalia | Connectivity | Topic | JDK 1.3 and JDBC 3.03 | Hello!I have a system development on JDK 1.3 and I need to use JDBC 3.03 to connect to Teradata V2R6.1.I try but I couldn't and the documentation says that I need JDK 1.4.Do you know if it is possi... |
705 | 06 Apr 2006 @ 08:22 PDT | lranger | Jobs | Reply | Teradata DBA needed in Toronto | The role is a short term contract in Toronto. I will consider candidates out of country, but they must have an active/valid work permit immediately. |
704 | 06 Apr 2006 @ 12:24 PDT | Ross Dunham | UDA | Topic | Data Modelling Consultants Required:-Unmissable Opportunity | To work for a leading global consulting services company which offer end to end solutions in 53 countries across 6 continents.You will have the fantastic opportunity to deliver data warehousing sol... |
703 | 05 Apr 2006 @ 11:43 PDT | Ranga-746 | Database | Reply | Identifying invalid views? | There is no straight forward answer to your problemHow ever i used to generate dynamic sql statementsfor each view like sel * from view1 where 1 = 2;I used put all this in bteq script.use ''.SET ER... |
702 | 05 Apr 2006 @ 07:55 PDT | Kks | Jobs | Reply | Teradata DBA needed in Toronto | is it open to only people authorised to work in Canada or people needing Work Permit can apply |
701 | 05 Apr 2006 @ 05:57 PDT | john bukowski | Jobs | Topic | looking for Cert. DBAs | I knew a person named Alex Miguel, does anyone know how to reach him? |
700 | 05 Apr 2006 @ 05:54 PDT | john bukowski | UDA | Topic | Omaha needs two DBAs | Hi,Not sure if my first post was accepted. I have a client in Omaha, NE who needs two DBAs email me for detail, these are contract to permanent opportunitiesjohn@hogangroup.com |
699 | 05 Apr 2006 @ 03:58 PDT | lranger | Jobs | Topic | Teradata DBA needed in Toronto | Urgent need for a contract Teradata DBA - Senior level experience with Teradata Query Manager, Priority Scheduler, WinDDI and Teradata Manager. Excellent opportunity for long term or full-time. ... |
698 | 05 Apr 2006 @ 01:34 PDT | Jim Chapman | Tools | Reply | Numeric overflow | It may be worth mentioning that the upcoming release V2R6.2 will support up to 38 digits for the DECIMAL data type. |
697 | 05 Apr 2006 @ 05:28 PDT | PGibbo Contract Recruit&Supply | Jobs | Reply | Teradata Professional needed (South Africa) | This is genuine, I am a recruiter for contractors. I am based in the UK, if you would like to register your details to be considered for contract work or indeed have a requirement to fill then feel... |
696 | 05 Apr 2006 @ 03:50 PDT | Amit | Tools | Reply | Numeric overflow | Thanks Barry!I thought there should be a straight forward way of doing it, but after looking at your reply I also believe that it could only be done this way in Teradata.Amit |
695 | 05 Apr 2006 @ 03:44 PDT | PGibbo Contract Recruit&Supply | Jobs | Reply | Teradata experts, careers advice needed please (UK based) | Hi Steve, I know this is a little out of date, I would be more than happy to see her details. 0121 237 3107 Monarch IT Recruitment- UK |
694 | 04 Apr 2006 @ 08:24 PDT | Kks | Jobs | Reply | Teradata Admin Needed in : Columbus, OH | How long is the contract, any relocation |
693 | 04 Apr 2006 @ 03:27 PDT | mike_nguyen | Database | Reply | How to get tablename | I found it:select tablename from dbc.tables where database=your databaseThanks,Michael |