How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
No Answer is Posted For this Question
Be the First to Post Answer
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?