Interested to Buy Any Domain ? << Click Here >> for more details...
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
- 1 Answers
- 3032 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer / himanshu gupta
First try to convert all names into same format(normalize) and then will insert all details to centralized database excluding duplicate record.
| Is This Answer Correct ? | 1 Yes | 0 No |
hi i gone though satyam interview. what is Acid Properties?
What do you understand by sql server agent?
What are the advantages dts has over bcp?
What is a derived table?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is the difference between a "where" clause and a "having" clause?
What do you mean by an execution plan?
Mention the differences between substr and charindex in sql server.
How many types of triggers are there?
What is partitioned view?
How to Generate a Series of Random Integers With T-SQL?
What are different types of join?
-
Oracle (3259) - 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)
