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
- 3086 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 |
According to you what goes into making the best database administrator? : sql server database administration
What is service broker?
Explain an automatic checkpoint
How to change server name in sql server?
What is filtered index?
Does sql server use t sql?
Explain ranking functions?
What do we need queues in sql service broker?
How many types of Outer Joins?What are they?
What is a performance monitor?
What are ddl triggers and types of ddl trigger?
What are the difference between primary keys and foreign keys?
-
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)
