How can we do data cleaning?
Answer / Sharvan Kumar
To perform data cleaning, you may follow these steps:
1. Removing duplicates
2. Handling missing values (imputation or deletion)
3. Removing outliers
4. Converting categorical data to numerical
5. Standardizing the format of dates and times
6. Correcting errors in spelling or syntax
| Is This Answer Correct ? | 0 Yes | 0 No |
What is VLDB?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain what are the different methods of loading dimension tables?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What is IQD file?
What are necessary tasks to install reportnet software?
What is the definition of cube in datawarehousing?
What is metadata in context of a datawarehouse?
Can we take backup when the database is opened?
Explain what is data validation strategies for data mart validation after loading process?
How can you set the client management?
Why do we use DSS database for OLAP tools?