What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
849How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
956How would you write a left join statement to return a result set of movie.title�s and director.name�s?
971Post New Data Warehouse General Questions
What is the difference between snowflake and star schema?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are templates in which way it is help full?
Explain me what are data marts?
if you use oracle sql*loader , how do you transform data with it during loading?
What is meant by metadata in context of a data warehouse?
What are data modeling and data mining?
Compare and contrast aggregates & indexes
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Explain is olap databases are called decision support system true/false?
What is surrogate key? Where we use it?
Explain swot analysis?
What is mean by aggregate aware?
What are the various file formats involved in reportnet?
Is there any difference in testing database and data ware housing?