Data Warehouse Developer interview questions – page 8

AS a Project Manager How to add value to your project?

How do you handle stress?

How does Microsoft Access database recover free space?

1,If there are 3 workflows are running and if 1st workflowfails then how could we start 2nd workflow or if 2ndworkflow fails how could we start 3rd workflow?

Write a query to to delete duplicate rows?

Can session assigned multiple mappings or not?

I am having table with two colums like empno,gender.in gender column, i am having records male,female like that .my final output will be male female5 6

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions?or In which case u use Unconnected lookup?

What is overloading procedure or overloading function ?

What are the difference between Functions/Stored Procs and Triggers and where are they used.

State some of the uses of MS Access?

Explain about relationships and look up fields?

What is the difference between "procedure" and "function"?

What is the SQL??

What is a self join? Explain it with an example?

What is the difference between primary key & foreign key?

Error severity 13 indicates what?

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

My table contain duplicate Records i wanna load uniq recordsto my table . i have to pass the uniq records throughfilter t/r how?

I wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

Write the query for find the top 2 highest salary in sql server

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task)1) open - Fetch loop 2) for loop

What are the modules in Power Mart?

Types of joins ?

How do you explain a complex technical issue to someone who has less technical knowledge than you?

When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?

How can we find out cardinality between two tables?

How can I enforce to use particular index?

Lets suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesn't contain any garbage values?

What is outer join?what is selef join?what is difference between them?what is cartecion join?