What are the validations performed on the source data? If
there are junk data available in the source data, how to
eliminate it?
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 |
Why do we need distributed database?
What advantages does DBMS have over traditional file systems?
Explain about ur projets on teradata???
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
what is cardinality
What do you mean by database?
what is Normalization means..?
8 Answers AZTEC, Bank Of America, Infosys, TCS,
plz suggest me the book for preparation of NIC exam.
What is a sequence? Explain it with one example?
What does specialization in DBMS mean?
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
What is the purpose of firebase?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)