All forum activity

#DateUserForumTypeThreadPost
106705 Jun 2006 @ 01:00 PDTJim ChapmanUDAReplyUnloads from DB2 (nullable fields) - How to manage this with Fastload?The NULLIF method doesn't work for numeric data types. To capture null values properly, you will need to convert your data to the kTeradata indicator format.
106605 Jun 2006 @ 06:49 PDTNidhiDatabaseTopicMigrating to V2R6Hello,We currently use Teradata V2R5 and TTU 7.1What changes should be done on the Client systems if we want to migrate to V2R6?Is intalling the TTU 8.0 on the Client/Server a must?Thanks,Nidhi
106505 Jun 2006 @ 05:15 PDTNidhiToolsTopicMigrating to V2R6Hello,We currently use Teradata V2R5 and TTU 7.1What changes should be done on the Client systems if we want to migrate to V2R6?Is intalling the TTU 8.0 on the Client/Server a must?Thanks,Nidhi
106405 Jun 2006 @ 03:40 PDTWiproiteAnalyticsTopicSiebel Analytics on existing Teradata DWHi Maestros ,We are implementing a Siebel Analytics DW schema on a Teradata DB. There is an existing legacy Teradata DW where we will be creating a new schema for Siebel Analytics.I learnt that in ...
106305 Jun 2006 @ 03:10 PDTjufuDatabaseTopicwhy this error was raised? help me!Hi, all: See the following, please! update TTEMP.TB_MID_NEW_INNET_SUBSCRIBER from PVIEW.VW_NET_GSM_NL_200604 a set Active_Month = 200604 where Phone_No = a.MSISDN and Active_Month is null ...
106204 Jun 2006 @ 09:01 PDTKksTrainingReplywhat is wrong with prometric?Yes I also experienced , there was problem . your credit card is safe
106103 Jun 2006 @ 08:01 PDTvictor4techAnalyticsReplyHow to format the output in teradataThanks Fred...I realised it is very difficult to change the attribute characteristics in teradata....
106003 Jun 2006 @ 07:23 PDTDEEPUUDAReplyAll the GURU'S out theirIf your min year is '1999' & max year is '2005'. That means (2005-1999 = 7) 7 times you can use - MAX(CASE WHEN RN = x THEN YEAR ELSE '' END)||','|| to achieve your result set.SEL ID_NO,NAME,MAKE,...
105902 Jun 2006 @ 03:51 PDTFredToolsReplyDate Comparisions - Differing formatsI think you are confusing external and internal representation. Is SOURCE_MONTHYEAR actually defined as DATE or is it CHAR that you know is supposed to represent a YYYYMM format date? The FORMAT sp...
105802 Jun 2006 @ 03:51 PDTFredToolsReplyDate Comparisions - Differing formatsI think you are confusing external and internal representation. Is SOURCE_MONTHYEAR actually defined as DATE or is it CHAR that you know is supposed to represent a YYYYMM format date? The FORMAT sp...
105702 Jun 2006 @ 10:39 PDTKoentjeUDATopicUnloads from DB2 (nullable fields) - How to manage this with Fastload?When unloading nullable data from DB2,you receive always two fields.Field one = ValueField two = Indicator if the field is null or not.Can you use fastload (eg. decimals) without creating two field...
105602 Jun 2006 @ 12:13 PDTPervez AhmedDatabaseReplyDifference between Teradata Utilities and ETL ProcessI am reviewing the link. Thanks a lot for your respons.Pervez Ahmed
105501 Jun 2006 @ 01:32 PDTJim ChapmanDatabaseReplyDifference between Teradata Utilities and ETL ProcessThis Wikipedia article may be helpful: http://en.widipedia.org/wiki/Etl
105401 Jun 2006 @ 12:32 PDTpmoe33ToolsReplyDate Comparisions - Differing formatsI'm not getting results back from this. SELECT SOURCE_MONTHYEARWHERESOURCE_MONTHYEAR (date, format 'yyyy/mm/dd') BETWEEN VARIABLE1 AND VARIABLE2VAR...
105301 Jun 2006 @ 12:16 PDTj355gaUDAReplyAll the GURU'S out theirIf your shop is using V2R6 you could try the WITH RECURSIVE clause to concatenate a column in an arbitrary number of rows into a single string. There is an example in this forum if you look at my ...
105201 Jun 2006 @ 12:12 PDTj355gaDatabaseReplyIs not [] supported by like pattern in TeraData?You are probably thinking of regular expressions which are not supported in Teradata. The only wild-card options you can use in the LIKE pattern match are % (any match of zero or more characters)...
105101 Jun 2006 @ 11:43 PDTDave DUDATopicEmbedded SQL for Suse LinuxI'm porting a program from an NCR platform to SUSE Linux that reads in a select statement from a file and outputs a delimited flat file. The code opens the connections, prepares the statement and ...
105001 Jun 2006 @ 09:15 PDTPervez AhmedUDAReplySeeking Data Warehousing Consultants for exciting careeer opportunitiesPlease see attached
104901 Jun 2006 @ 08:40 PDTPervez AhmedDatabaseTopicDifference between Teradata Utilities and ETL ProcessI am sort of confused in differentiating between teradata utilities such as FastLoad and MLoad that are used for loading external data into teradata tables and ETL process. I understand ETL process...
104801 Jun 2006 @ 06:42 PDTstami27-2406ToolsReplyEncountering error while using .EXPORT REPORT FILE command in BTEQHi,the only think to suggest is that some subdirectory from /werr1/we1s/ws/ABX_logdoes not exist.The Code is Ok except, you must have received some Warnings such:"*** Warning: Expected a '.' before...
104701 Jun 2006 @ 04:59 PDTjufuDatabaseTopicIs not [] supported by like pattern in TeraData?i cannot understand why aField like '[0-9][0-9]' does not work.
104601 Jun 2006 @ 04:51 PDTjufuAnalyticsTopicwhy does not aField like '[0-9][0-9]%' work?Is not the usage of [] in like pattern supported in TeraData?
104501 Jun 2006 @ 04:34 PDTDanUDATopicAll the GURU'S out theirHi Guys, I need help with the following please;I’ve got a table that looks like this,ID_NO NAME MAKE YEAR1 John Blue 20001 John Blue 20011 John Blue 20032 ...
104401 Jun 2006 @ 03:48 PDTDanAnalyticsTopicHOW DO I ? ? ? ?Hi Guys, I need help with the following please;I’ve got a table that looks like this,ID NO NAME MAKE YEAR1 John Blue 20001 John Blue 20011 John Blue 20032 Mary Black 19992 Mary Black 20013 Gerry ...
104331 May 2006 @ 11:03 PDTI_SQL_TODAYUDATopicP**** City State ZipHello Folks,We are getting City State ZIP information all in one field - like this'BAYTOWN TX....................77520'or 'BAY CITY.......TX.............77414'where '.....' means spacesany suggesti...

Pages