How would you write a simple stored procedure in tsql which takes a movie

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

Question Posted / vaibhav dixit

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

Explain why should you put your data warehouse on a different system than your oltp system?

WHAT IS FACT LESS FACT TABLE?

in general which algorithms for used?

What is dimensional modelling?

What is pre-emptive and non-pre-emptive?

What is prompt types of prompts?use of prompts syntax of prompt?

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

What is a cube in data warehousing concept?

What are modeling tools available in the market?

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

What is Analysis Services?

Ist the schema that a data warehouse system can implements.

For more Data Warehouse General Interview Questions Click Here