What are the validations performed on the source data? If
there are junk data available in the source data, how to
eliminate it?



What are the validations performed on the source data? If there are junk data available in the sour..

Answer / Pawan Kumar Tiwari

The validations performed on the source data depend on the specific database and the application. However, common validations include checking for null values, data type mismatches, duplicate records, and range checks. To eliminate junk data, you can use SQL queries with WHERE clauses to filter out unwanted records, or use data cleaning tools like Trim, RTRIM, LTRIM, and UPPER/LOWER functions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

Why do we need distributed database?

1 Answers  


What advantages does DBMS have over traditional file systems?

1 Answers   ABB, Infogain,


Explain about ur projets on teradata???

1 Answers   Wipro,


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

1 Answers  


what is cardinality

3 Answers   CSC,


What do you mean by database?

1 Answers  


what is Normalization means..?

8 Answers   AZTEC, Bank Of America, Infosys, TCS,


plz suggest me the book for preparation of NIC exam.

10 Answers   NIC,


What is a sequence? Explain it with one example?

1 Answers   BirlaSoft,


What does specialization in DBMS mean?

1 Answers   BirlaSoft,


Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1 Answers  


What is the purpose of firebase?

1 Answers  


Categories