1067 | 05 Jun 2006 @ 01:00 PDT | Jim Chapman | UDA | Reply | Unloads 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. |
1066 | 05 Jun 2006 @ 06:49 PDT | Nidhi | Database | Topic | Migrating to V2R6 | Hello,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 |
1065 | 05 Jun 2006 @ 05:15 PDT | Nidhi | Tools | Topic | Migrating to V2R6 | Hello,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 |
1064 | 05 Jun 2006 @ 03:40 PDT | Wiproite | Analytics | Topic | Siebel Analytics on existing Teradata DW | Hi 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 ... |
1063 | 05 Jun 2006 @ 03:10 PDT | jufu | Database | Topic | why 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 ... |
1062 | 04 Jun 2006 @ 09:01 PDT | Kks | Training | Reply | what is wrong with prometric? | Yes I also experienced , there was problem . your credit card is safe |
1061 | 03 Jun 2006 @ 08:01 PDT | victor4tech | Analytics | Reply | How to format the output in teradata | Thanks Fred...I realised it is very difficult to change the attribute characteristics in teradata.... |
1060 | 03 Jun 2006 @ 07:23 PDT | DEEPU | UDA | Reply | All the GURU'S out their | If 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,... |
1059 | 02 Jun 2006 @ 03:51 PDT | Fred | Tools | Reply | Date Comparisions - Differing formats | I 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... |
1058 | 02 Jun 2006 @ 03:51 PDT | Fred | Tools | Reply | Date Comparisions - Differing formats | I 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... |
1057 | 02 Jun 2006 @ 10:39 PDT | Koentje | UDA | Topic | Unloads 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... |
1056 | 02 Jun 2006 @ 12:13 PDT | Pervez Ahmed | Database | Reply | Difference between Teradata Utilities and ETL Process | I am reviewing the link. Thanks a lot for your respons.Pervez Ahmed |
1055 | 01 Jun 2006 @ 01:32 PDT | Jim Chapman | Database | Reply | Difference between Teradata Utilities and ETL Process | This Wikipedia article may be helpful: http://en.widipedia.org/wiki/Etl |
1054 | 01 Jun 2006 @ 12:32 PDT | pmoe33 | Tools | Reply | Date Comparisions - Differing formats | I'm not getting results back from this. SELECT SOURCE_MONTHYEARWHERESOURCE_MONTHYEAR (date, format 'yyyy/mm/dd') BETWEEN VARIABLE1 AND VARIABLE2VAR... |
1053 | 01 Jun 2006 @ 12:16 PDT | j355ga | UDA | Reply | All the GURU'S out their | If 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 ... |
1052 | 01 Jun 2006 @ 12:12 PDT | j355ga | Database | Reply | Is 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)... |
1051 | 01 Jun 2006 @ 11:43 PDT | Dave D | UDA | Topic | Embedded SQL for Suse Linux | I'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 ... |
1050 | 01 Jun 2006 @ 09:15 PDT | Pervez Ahmed | UDA | Reply | Seeking Data Warehousing Consultants for exciting careeer opportunities | Please see attached |
1049 | 01 Jun 2006 @ 08:40 PDT | Pervez Ahmed | Database | Topic | Difference between Teradata Utilities and ETL Process | I 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... |
1048 | 01 Jun 2006 @ 06:42 PDT | stami27-2406 | Tools | Reply | Encountering error while using .EXPORT REPORT FILE command in BTEQ | Hi,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... |
1047 | 01 Jun 2006 @ 04:59 PDT | jufu | Database | Topic | Is not [] supported by like pattern in TeraData? | i cannot understand why aField like '[0-9][0-9]' does not work. |
1046 | 01 Jun 2006 @ 04:51 PDT | jufu | Analytics | Topic | why does not aField like '[0-9][0-9]%' work? | Is not the usage of [] in like pattern supported in TeraData? |
1045 | 01 Jun 2006 @ 04:34 PDT | Dan | UDA | Topic | All the GURU'S out their | 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 ... |
1044 | 01 Jun 2006 @ 03:48 PDT | Dan | Analytics | Topic | HOW 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 ... |
1043 | 31 May 2006 @ 11:03 PDT | I_SQL_TODAY | UDA | Topic | P**** City State Zip | Hello 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... |