Data Warehouse Developer – Page 2

Ques:- What is the Query Optimizer. How you optimize your qeury.

Ques:- What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level? Transaction isolation levels are used when we go for transactions in stored procedures used in Transact SQL.

Ques:- I have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

Ques:- Tell me about a specific task you undertook, which was a challenge for you?

Ques:- When do you expect to make your final decision?

Ques:- What is difference between function and procedure?

Ques:- Using subquery how can i calculate working days in a month?

Ques:- How do you change a password for an existing user via mysqladmin?

Ques:- Does SQL SERVER Supports “Finally” block?

Ques:- 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.

Ques:- Explain about managing data tasks?

Ques:- The default type of Constants and variables supported by TSLare..

Ques:- What is the difference between Power Center & Power Mart?

Ques:- Provide all the built in string function of SQL SERVER

Ques:- Where do we use semi and non additive facts

Ques:- What is the metadata extension?

Ques:- State some criteria`s and their effects on a ms access database?

Ques:- Without matching columns in two tables. how can you join

Ques:- State the criteria which a trusted publisher should meet before adding him?

Ques:- Can any one give me an example for factless fact table ?If your answer is studunt attendence registration,could you plese give me explanation for this ?

Ques:- What is partitioning? What are the types of partitioning?

Ques:- What is the advantge and disadvantage of mysql_connet() andmysql_pconnect() ? in which condition will you usemysql_connect() and mysql_pconnect().

Ques:- What are the various transformation available?

Ques:- How to calcuate the second highest salary of he employee

Ques:- Tell me about a time you got totally fed up on the job. What did you do after that?

Ques:- How can I open an MS Access database that has been converted to a current version?

Ques:- How do you select a row using indexes in DB2?

Ques:- What is Sql Native Client?

Ques:- What is maximum size of a database in MySQL?

Ques:- How to write query to Delete the records in child table and corresponding records in parent table