
	Home > Oracle Database / Applications Tips > Oracle data warehousing > Keep null values

Oracle Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

ORACLE DATA WAREHOUSING

Keep null values

Will Condon
05.22.2001
Rating: --- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

Avoid converting null values to zero. Some ETL processes transform null values to zero. This creates a problem for data mining applications. A variable with a zero value will be considered valid by the data mining app although it should be ignored if it is truly null.

For More Information

What do you think about this tip? E-mail us at editor@searchDataWarehousing.com with your feedback.
The Best ETL Web Links: tips, tutorials, and more.
Have an ETL tip to offer your fellow DW gurus? The best tips submitted will receive a cool prize--submit your tip today!
Ask your technical ETL questions--or help out your peers by answering them--in our live discussion forums.
Ask the Experts: Our ETL guru is waiting to answer your toughest questions.

Rate this Tip
To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Oracle data warehousing
	Tip: Exposing logical attributes with virtual columns
	Top five data management buzzwords
	A bit wiser with Oracle technology
	Core principles of data warehouse design
	Saving lives with Oracle
	The BI application consolidation challenge
	MetaBase scripting for the Oracle data warehousing DBA
	The case for data stewardship
	Why OLAP deserves more attention
	Beyond reporting: Getting value out of your data

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Oracle Development Solutions - SQL, J2EE, XML, SOA

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy