query to Compare data of two tables between two different Databases(Oracle and SQL Server)
Eg.,
Source Database: Oracle
Table: Employee
Target Database : SQL Server
Table : emp
No Answer is Posted For this Question
Be the First to Post Answer
Why do we need distributed database?
Write a query to retrieve for many to many relationships?
CLI stands for?
how to implement dense rank in rank transformation in Informatica? so that output should be like 1,1,2,3 and not like 1,2,3,4
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What are the disadvantages of views in a database?
Explain transaction manager?
Differentiate between unique key and foreign key?
How concurrency problems effect the database?
Is it good to store images in database?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
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)