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
- 2278 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 |
What do you mean by table and field in sql?
What do you mean by an execution plan? Why is it used?
What is sqlcmd?
Is index a datbase objects in sql server?
How to change location of errorlog in SQL?
What is t-sql script to take database offline – take database online.
What are the operating modes in which database mirroring runs?
What is the main purpose of having conversation group?
Explain syntax for disabling triggers?
what is a join? : Sql server database administration
How to modify existing triggers using "alter trigger"?
Explain ms sql server reporting services vs crystal reports?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
