Question: Please explain what policy/procedures/validation you would apply to ensure the follow bad data is not stored in the Warehouse Data Quality - Types of Data

Please explain what policy/procedures/validation you would apply to ensure the follow bad data is not stored in the Warehouse

Data Quality - Types of Data Quality Problems

Dummy values in source system fields
Absence of data in source system fields
Multipurpose fields
Cryptic data
Contradicting data
Improper use of name and address lines
Violation of business rules
Reused primary keys
Non-unique identifiers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

5, Putting Together an Evaluation Matrix An evaluation plan is a written document that describes the cWill/mat\Questions to ask yourself when putting together an evaluation matrix: Evaluation...

Q:

ETHICS AND DATA GOVERNANCE It's essential that data is credible and reliable. Are your data sources trustworthy? Who owns the data? Having clear data fields, definitions, and owners isn't something...

Q:

ENGR 630: Quality and Reliability Management 1. You are required to read lecture notes of Six Sigma. You are encouraged to read any Six Sigma reference books and materials to help you understand its...

Q:

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Q:

Simulated Business JKL Industries Business and strategic planning FY 2014-2015...................................1 Operational...

Q:

Simulated Business JKL Industries Business and strategic planning FY 2014-2015...................................1 Operational...

Q:

Simulated Business JKL Industries Business and strategic planning FY 2014-2015...................................1 Operational...

Q:

Simulated Business JKL Industries Business and strategic planning FY 2014-2015...................................1 Operational...

Q:

Simulated Business JKL Industries Business and strategic planning FY 2014-2015...................................1 Operational...

Q:

please reas the instruction instructions are below the. write a report after reading the article only responsibilties of CEO CEO/President Job Title: CEO/President FLSA Status: EEO Code: Salary...

Q:

A company has identified two possible investment projects, Project A and Project B, with the following expected cash flows: Year Project A Project B 1 $10,000 $5,000 2 $15,000 $10,000 3 $20,000...

Q:

What are the differences between formal small group networks and the grapevine?

Q:

1 Explain the rules of company law which regulate the making of distributions by public companies, private companies and investment companies. Indicate also the consequences which can follow the...

Q:

Decision Trees are good for interpreting data, numerical and non - numerical, in a highly visual way with minimal preparation or data scrubbing before use True False

Q:

3.111 A professor finds that she awards a final grade of A to 20% of her students. Of those who obtain a final grade of A, 70% obtained an A on the midterm examination. Also, 10% of the students who...

Q:

3.109 In a large city, 8% of the inhabitants have contracted a particular disease. A test for this disease is positive in 80% of people who have the disease and is negative in 80% of people who do...

Q:

3.108 The Customs Inspection agency at international airports has developed a traveler profiling system (TPS) to detect passengers who are trying to bring more liquor into the country than is allowed...