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
- 3026 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 |
Is the log file is a part of file group?
what is the difference between group and having give an example with query and sample output
Explain the architecture of ms sql reporting service?
Can you explain what are various ways to enhance the ssrs report?
how to improve the speed of SQL database server and how to avoid dead lock?
How to delete duplicate rows from table except one?
How column data types are determined in a view?
Explain Geography datatype in SQL Server
How to create an multi-statement table-valued function?
What are the events recorded in a transaction log?
What does select 1 mean?
How to change location of errorlog in SQL?
-
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)
