Properly formulated, a DW only reports on what happened, and ignores what did not happen. If it's really like a DW then you just leave the nulls out. You should do this if you can.
Otherwise you have to decide how to lie based on least harm to aggregates. If you average or sum you should use 0 to avoid messing up the sums. If you can use a conditional code to skip a negative, and the negative is not allowed, -1 makes a good null, but you wouldn't want to sum it into an account or anything. Blanks may be an option depending on how Seibel interperets them, but it's probably a coding error. For a varchar I'd use a zero-length string or a single blank, if zero-length isn't allowed. If blanks are significant, first shoot your source system designer, then use '<NULL>'. :) paquette stephane wrote: > Hi, > > We're in the process of writing functionnal specs for > a system which is like a DW but instead of a DW the > staging area push the data in Siebel. > > If we replaced null by something else. > What would you choose : > for a varchar field ? > for a numeric field ? > > Someone has proposed blanks for the character field > but I'm not comfortable with that. > > TIA > > ===== > St�phane Paquette > DBA Oracle et DB2, consultant entrep�t de donn�es > Oracle and DB2 DBA, datawarehouse consultant > [EMAIL PROTECTED] > > __________________________________________________________ > L�che-vitrine ou l�che-�cran ? > magasinage.yahoo.ca > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
