The tag has no usage guidance, but it has a tag wiki.

learn more… | top users | synonyms

5
votes
1answer
149 views

Best Practice for SQL Server data validation

I have CSV files that I would like to import into SQL Server 2014. Each record in the files has around 20 columns, each of them should be validated for data type compliance as well as some other ...
2
votes
1answer
122 views

How to validate data before loading it to DB

I have a situation where in I have million records in CSV file, what I need to do is to apply some business validation on certain columns of CSV and load data to DB only if particular record is valid. ...
1
vote
1answer
47 views

MySQL-load data infile- invalid data validation

Is it possible to validate the data and load it in a table using 'load data infile'? This is the query load data local infile 'C:/Users/970685/Desktop/SFcheck.csv' into table ...
0
votes
0answers
22 views

Why is my valid index not working with DBMS_COMPARISON.CREATE_COMPARISON?

Thanks in advance. I'm trying to use the DBMS_COMPARISON utility to check records in the existing schema vs. other linked databases. The table has a composite primary key. It consists of the NAME ...
3
votes
1answer
180 views

Table structure for validating data using category and subcategory fields

I am creating a simple budget application, and the primary table will be a transaction table that contains things like the amount of the transaction, date, account, the category and subcategory (the ...
1
vote
1answer
26 views

Can I enforce one field being dependent on another?

I would like to know if it's possible to have two fields (in this case bits) in the same table where one is dependent on another. For example Check2 may only be true if Check1 is true. Note: I'm ...
0
votes
1answer
43 views

Multiple queries and a report

im fairly new to databases. I have multiple query's that i normally run individually at the end of loading data to my table doing simple integrity checks like length ,char types and so on (see ...
1
vote
1answer
116 views

Compare table content from different PostgreSQL 9.3 DBs

The problem How do I efficiently and idiomatically compare the content of two tables, each in a different DB? I have 3 DBs (the classic dev, stg and prod). Each DB has a few tables which should be ...