Re: A question of principle

In article <32714DFC.252B_at_hk.super.net>, <infoage_at_hk.super.net> writes:
> Path: news.ou.edu!news.nodak.edu!netnews1.nwnet.net!netnews.nwnet.net!reuter.cse.ogi.edu!engr.orst.edu!newsfeed.orst.edu!richie.supra.com!uunet!in2.uu.net!nntp.hk.super.net!tst.hk.super.net!usenet
> From: Michael Ho <infoage_at_hk.super.net>
> Newsgroups: comp.databases.oracle,comp.databases.oracle.misc
> Subject: Re: A question of principle
> Date: Fri, 25 Oct 1996 16:32:12 -0700
> Organization: Infoage Consultant
> Lines: 15
> Message-ID: <32714DFC.252B_at_hk.super.net>
> References: <01bbc113$f9982de0$6b19d280_at_freh-nt-007>
> NNTP-Posting-Host: max6-249.hk.super.net
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 3.0Gold (Win16; I)
> To: Bard <bwskiles_at_adpc.purdue.edu>
>
> Bard wrote:
>
> > I am a DBA. We have several developers working with our setup of Oracle
> > Data Warehouses. The source of our data is a mainframe.
 

> > The question of principle has to do with transferring mainframe practices
> > to the Oracle warehouse. Primarily, the use of "blanks" or "spaces" in
> > place of NULLs. I am, on principle, opposed to using blanks where nulls
> > ought to be. I find the blanks to be misleading and a misuse of Oracle.
 I
> > also believe it sets a poor precedence for future Oracle applications.
>
>
>
>
> Your DB on mainframe doesn't support NULL ?
>
I agree, My DW is in a simular situation. We have had to use a space for NOT NULL fields though. all other fields we convert into null useing DIRECT LOAD Options. Their is no need to use up valuable space with SPACE. HA HA

Martin Douglas Received on Sat Oct 26 1996 - 00:00:00 CEST