Keep null values

Keep null values

Will Condon

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.

Requires Free Membership to View

Login

By submitting your registration information to SearchOracle.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchOracle.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Dig Deeper

People who read this also read...

Related glossary terms

Terms for Whatis.com - the technology online dictionary

Show me more

This was first published in June 2001

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

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.

More from Related TechTarget Sites

Data Management
Business Analytics
SAP
SQL Server
Java
Data Center
Content Management
Financial Applications

Data Management
- New GigaSpaces release promises 'big data' analytics in real time
  
  The latest version of GigaSpaces XAP is designed to let users create their own real time "big data" analytics platform, and more big data news from around the Web.
- People, process issues offer path to improve data quality on the cheap
  
  Educating end users and upgrading internal processes can help enterprises fix data quality problems without dropping a ton of cash, analysts say.
- As data demands speed up, information management tools pave road ahead
  
  New research shows data virtualization, data governance and master data management initiatives provide higher levels of satisfaction with data quality and data integration.
Business Analytics
- Eckerson: 'Big data' analytics weighs a mix of the old and new
  
  In a video interview, business intelligence analyst Wayne Eckerson offers tips on using big data analytics software and related big data technology. He also gives his view of what big data really is.
- To glean value from 'big data' projects, it may take more than Hadoop
  
  Organizations will have to push beyond storage requirements and basic business intelligence tools to exploit big data, according to a Gartner analyst.
- On the go the way to go? Answer lies with building mobile BI business case
  
  According to a recent Gartner survey, mobile technology is the second most important priority for CIOs in 2012, but building the business case is easier said than done.
SAP
- Building a foundation with SAP Data Services
  
  In this SAP Press book chapter excerpt, learn how to build a strong data foundation using the functionality in the SAP Data Services package.
- Mark Smith explains SAP's HANA, PaaS and predictive analytics moves
  
  Ventana Research CEO Mark Smith offered up his take on SAP's announcements around HANA, the cloud and predictive analytics at the annual Sapphire conference.
- Jon Reed dissects SAP's cloud strategy
  
  Sapphire 2012 is in the books and, unsurprisingly cloud was a major topic. SAP mentor Jon Reed shares his thoughts on what SAP had to say about modular applications, PaaS and SuccesFactors in this video.
SQL Server
- Pssdiag and Sqldiag Manager – the lifeblood of SQL troubleshooting
  
  What’s the most important part of SQL troubleshooting? Pssdiag and Sqldiag manager, says SQL Server professional Serdar Yegulalp. Find out what makes Pssdiag and Sqldiag so important.
- More T-SQL statements in SQL Server 2012 you need to know about
  
  In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more.
- Three new T-SQL commands in SQL Server 2012 to make your life easier
  
  Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors.
Java
- FuseSource releases enterprise products at CamelOne 2012
  
  Here at CamelOne 2012, FuseSource is releasing two new products – Fuse ESB Enterprise 7.0 and Fuse MQ Enterprise 7.0.
- Open source integration framework keeps motorists safe in the UK
  
  Automotive rescue and recovery services in the UK gained significant messaging advantages over the past few years. The new Automotive Network Services (ANS) system, built and maintained by Apex Networks, connects automotive clubs and insurance agencies with the mechanics, riggers, and first responders that provide emergency services to accidents and disabled vehicles.
- Scaling up and scaling out to meet new business demands
  
  Scaling up and scaling out are two ways for growing businesses to increase productivity, but doing so blindly may be more costly than it's worth.
Data Center
- Are private data centers an endangered species?
  
  Businesses can save millions by leasing data center space rather than building their own, but some feel private data centers are the best bet.
- Facebook Open Compute Project a role model for data centers
  
  Data center experts say most enterprises can’t imitate Facebook’s Open Compute Project, but they could reap the benefits over time.
- Optimize data center virtualization with strategic capacity planning
  
  Use strategic capacity planning to future-proof your data center's virtualization efficiency and make the most of server hardware.
Content Management
- No effective information governance without change management, expert says
  
  Successful information governance involves a combination of smart processes and the appropriate corporate culture, says consultant Carol Stainbrook.
- Trash the old data: A firm record retention schedule can lead to DM success
  
  Information is growing exponentially and the lack of firm record retention schedules is costing organizations big money and will increase liability as time passes, says consultant Randolph Kahn.
- Cimarex picks Accellion enterprise collaboration platform over SharePoint
  
  Cimarex Energy replaced its SharePoint system with Accellion’s enterprise collaboration platform for secure mobile file sharing and uses it to recruit graduate geology students.
Financial Applications
- Cloud-based dynamic discounting fuels small tech supplier’s growth
  
  One small tech company uses Ariba Network to give cash-rich Fortune 500 customers discounts for early payment of electronic invoices.
- SaaS HR, mobile analytics upends workforce management software market
  
  Nucleus Research names Ceridian, ADP among top performers and finds threats to legacy leader Kronos.
- Basic planning, data cleansing seen as crucial to HR system integration
  
  Save time and money by establishing human resources processes and scrubbing data before embarking on a project to integrate systems, industry watchers say.

All Rights Reserved, Copyright 2003 - 2012, TechTarget