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

What are snapshots? What are materialized views & where do we use them?

Explain what are fact, dimension, and measure?

What are the data types present in bo? What happens if we implement view in the designer n report?

What are parallel querys and query hints?

What is operational data store (ods)?

Explain what are the different methods of loading dimension tables?

Suppose we want to display zero when null values coming to report how can we do that?

Where we use surrogate key explain with example?

What is confirmed dimension?

What is the metadata extension?

What is meant by metadata in context of a data warehouse and how it is important?

What is a ETL/ How does Oracle support the ETL process?

For more Data Warehouse General Interview Questions Click Here