What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
897How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
1004How would you write a left join statement to return a result set of movie.title�s and director.name�s?
1029Post New Data Warehouse General Questions
What is a data warehousing?
What are the key columns in Fact and dimension tables?
Explain the definition of normalized and denormalized view?
What is the difference between view filter and report filter?
Explain a mapping, session, worklet, workflow, mapplet?
Explain degenerate dimension table?
Is there any default username & pwd for bo designer & supervisor?
What is called data cleaning?
Explain what is batch and describe about types of batches?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is the difference between datawarehouse and bi?
Why we use repository connectivity?
How to define a cube??
What is surrogate key? Where we use it?
Explain ddl (data definition language)?