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
- 2605 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 trigger and its types?
Explain concepts of analysis services?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What command do we use to rename a database?
What is “asynchronous” communication in sql server service broker?
Do you know what are the restrictions that views have to follow?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
How many types of database relationship in sql server?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
How many nested transaction can possible in sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What are a scheduled jobs?
-
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)
