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
- 2679 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 |
Explain transaction server distributed transaction?
What is the maximum rows in sql server table?
What is importing utility?
What is set nocount on and what is set nocount off?
What are the recovery models in sql server 2000?
Why use triggers?
How to create a user name in a database?
What is "scheduled jobs" or "scheduled tasks"?
What are SSL and TSL protocols?
Can you explain about buffer cash and log cache in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Why use cursor in sql server?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
