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

Can any one explain the hierarchies level data warehousing.

What are the differences between star and snowflake schema?

What is MODEL is Data mining world?

What are fact, dimension, and measure?

What are the types of dimensional modeling?

Explain how are the dimension tables designed?

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

what is difference between drill & scope of analysis?

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

What is hash partition?

wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.

Explain the definition of normalized and denormalized view and what are the differences between them?

For more Data Warehouse General Interview Questions Click Here