12. NULL in MDM

12. NULL in MDM

12. What is NULL and how is it used in MDM?

a. Blank
b. Data marker
c. Empty

ANSWER: B

NULL is a special data marker. It denotes missing or not populated yet data. It can't be treated as an existing value and doesn't participate in equations of uniqueness integrity. That is, multiple records are permitted to have NULL for a unique field. To prevent records from having these undefined records, use validation functions IS_NULL and IS_NOT_NULL. Also, nulls can be handled through import manager.

Requires Free Membership to View

Login

When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

Hannah Smalltree, Editorial Director

By submitting your registration information to SearchSAP.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 SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Dig Deeper

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- Collaborative Master Data Management (CMDM)

Show me more

This was first published in September 2006

More from Related TechTarget Sites

Manufacturing ERP
Oracle
Data Management
Data Management UK
Business Analytics
CRM
Content Management
Financial Applications

Manufacturing ERP
- Collaboration technology driven by culture, communication gaps
  
  Industry experts explain how to match collaboration software such as chat, social media and conferencing with the needs of the organization.
- Manufacturer to move hosted JD Edwards ERP to 'virtual private cloud'
  
  In 11 years, EnterpriseOne ERP system has migrated from on-premises to physical and virtual servers at managed hosting provider. Next: private cloud.
- Five signs your multiple ERP systems are out of control
  
  Many manufacturers run multiple ERP systems -- or multiple instances of one system. But there are significant downsides to operating this way.
Oracle
- Integrating non-Oracle applications into Oracle environments
  
  Oracle application integration becomes even more complicated when trying to integrate Oracle applications and databases with non-Oracle applications.
- Integrating Oracle applications brings complexity
  
  Oracle’s various investments and acquisitions over the past decade have some customers struggling to integrate it all, although Oracle’s own middleware might be able to help.
- Implementing a Hyperion system in 3 weeks -- it can be done
  
  An Oracle Hyperion system implementation in three weeks? Yes, it can be done. Communications firm Neustar implemented Hyperion in less than a month and gained efficiencies in the process.
Data Management
- Oracle to financial firms: Speed is the key to avoiding systemic risk
  
  Financial services firms need to speed up their data management and analytics practices to avoid another economic crisis like the one that gripped the world in 2008.
- 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.
DataManagement UK
- SAS: High-performance analytics frees data scientists to model faster
  
  High-performance analytics on "big data" could aid European companies as they struggle to make headway in the recession, say senior SAS executives. All sectors are turning to big data, they claim.
- Organisational design for analytics function needs governance
  
  Scant are the absolute rules for the organizational design of the analytics function. It can be outsourced or in-house; sit within a business unit or run from the centre. But it needs governance.
- History lesson points way forward on data management projects
  
  Data management projects often suffer from historic amnesia. Projects that co-locate business and IT staff and keep to a manageable scale can achieve remarkable results, says consultant Andy Hayler.
Business Analytics
- BI, analytics and performance management software sees growth in 2011
  
  Gartner’s 2011 revenue estimates indicate the worldwide BI, analytics and performance management software market experienced another strong year, with figures that look remarkably similar to 2010.
- Tyagi: 'Big data' technology a solution in search of right problems
  
  Not every data problem requires "big data" technology, says consultant Vineet Tyagi. In a video Q&A, he discusses good uses for big data tools and offers tips on managing a big data project.
- IT bottlenecks drive data visualization tool purchases
  
  Allstate, Autodesk, MGM Resorts and Great Western Bank share the secrets to data visualization tools’ success.
CRM
- Mohegan Sun bets big on Infor CRM across sales, service and marketing
  
  Mohegan Sun's new CRM software platform aims to connect with customers, reduce agent churn and overhaul the sales force.
- Salesforce opens new channels with Chatter
  
  Denis Pombriant sees Salesforce.com's new screen sharing and instant messaging features as long-overdue changes to front office collaboration.
- New call center certification targets social media
  
  CIAC certification now includes testing on the use of social media in call centers.
Content Management
- Easier collaboration drives need for scalable document management strategy
  
  Collaboration, audit and compliance are among the business drivers of scalable document management initiatives even as it becomes easier to engage with content being amassed in growing repositories.
- 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.
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 2000 - 2012, TechTarget