I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

1

If user is owning any SQL Objects, can we drop that user

2137

List some mysql advantages and disadvantages?

1018

Explain primary key and foreign key constraints?

1104

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1183

What do you mean by atomicity and aggregation?

963

How to set the current database in ms sql server?

1154

Describe a subquery.

1111

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1220

Define full outer join in sql server joins?

1064

What is tuple in dbms?

930

Explain what are service-specific middleware?

1035

Can a procedure in a package be overloaded?

1108

What are the differences between clustered and non-clustered index?

1089

How to connect ms access to sql servers through odbc?

1081