All forum activity

#DateUserForumTypeThreadPost
71710 Apr 2006 @ 12:28 PDTdwuser123DatabaseTopicDownload 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...
71610 Apr 2006 @ 12:12 PDTMikeDatabaseTopicweird 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...
71510 Apr 2006 @ 12:06 PDTggToolsReplyTpump - 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 ...
71410 Apr 2006 @ 01:50 PDTyoungDatabaseReplyIdentity 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â...
71309 Apr 2006 @ 04:47 PDTdwuser123UDATopicDownload Great IBM 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...
71208 Apr 2006 @ 04:42 PDTdnoethTrainingReplyHow many Certified Teradata MastersHi Job_Agent,during last year's Partners the official count was announced to be about 750...Dieter
71107 Apr 2006 @ 09:53 PDTredsharkAnalyticsTopicUpdating a table from an imported fileIs 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...
71006 Apr 2006 @ 08:22 PDTKksTrainingReplyHow many Certified Teradata MastersNow there are many Masters , infact you cannot count, from Beijing to toronto thousands of them .
70906 Apr 2006 @ 07:19 PDTTechSmartsJobsTopicTeradata DBAs : Omaha, NEI 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 ...
70806 Apr 2006 @ 02:33 PDTnudoamToolsReplyTpump - 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...
70706 Apr 2006 @ 02:12 PDTshaik.feroz@aaa-calif.comToolsReplyTpump - 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...
70606 Apr 2006 @ 12:51 PDTNataliaConnectivityTopicJDK 1.3 and JDBC 3.03Hello!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...
70506 Apr 2006 @ 08:22 PDTlrangerJobsReplyTeradata DBA needed in TorontoThe 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.
70406 Apr 2006 @ 12:24 PDTRoss DunhamUDATopicData Modelling Consultants Required:-Unmissable OpportunityTo 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...
70305 Apr 2006 @ 11:43 PDTRanga-746DatabaseReplyIdentifying 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...
70205 Apr 2006 @ 07:55 PDTKksJobsReplyTeradata DBA needed in Torontois it open to only people authorised to work in Canada or people needing Work Permit can apply
70105 Apr 2006 @ 05:57 PDTjohn bukowskiJobsTopiclooking for Cert. DBAsI knew a person named Alex Miguel, does anyone know how to reach him?
70005 Apr 2006 @ 05:54 PDTjohn bukowskiUDATopicOmaha needs two DBAsHi,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
69905 Apr 2006 @ 03:58 PDTlrangerJobsTopicTeradata DBA needed in TorontoUrgent 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. ...
69805 Apr 2006 @ 01:34 PDTJim ChapmanToolsReplyNumeric overflowIt may be worth mentioning that the upcoming release V2R6.2 will support up to 38 digits for the DECIMAL data type.
69705 Apr 2006 @ 05:28 PDTPGibbo Contract Recruit&SupplyJobsReplyTeradata 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...
69605 Apr 2006 @ 03:50 PDTAmitToolsReplyNumeric overflowThanks 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
69505 Apr 2006 @ 03:44 PDTPGibbo Contract Recruit&SupplyJobsReplyTeradata 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
69404 Apr 2006 @ 08:24 PDTKksJobsReplyTeradata Admin Needed in : Columbus, OHHow long is the contract, any relocation
69304 Apr 2006 @ 03:27 PDTmike_nguyenDatabaseReplyHow to get tablenameI found it:select tablename from dbc.tables where database=your databaseThanks,Michael

Pages