After normalization, what are the conditions which have to keep in mind to de-normalize it?
issues involved in modeling and building data werahouses
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
How heap is implemented in database?
What is the difference between primary key, foreign key and candidate key?
Which is the best graph database?
Can a database table exist without a primary key?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Explain various types of locks in a transaction? Which is better and why?
What is the difference between data source and database?
What is the purpose of firebase?
What is the difference between a stored procedure and a query?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What are indexes in oracle?
diff b/w inter process and in process