What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
956How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
1053How would you write a left join statement to return a result set of movie.title�s and director.name�s?
1097Post New Data Warehouse General Questions
Explain what is the extension of file to save template?
How to improve session performance in aggregator transformation?
Explain what is difference between query studio and report studio?
Ist the schema that a data warehouse system can implements.
What is surrogate key? Where we use it? Explain with examples.
What is difference macros and prompts?
Can we start and stop single session in concurent bstch?
What is data analysis? Where it will be used?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Which component has onread method and what it is used for?
What is a functional dependency f said to be minimal?
What are the types of partitioning?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain what are the advantages data mining over traditional approaches?
what are the major three types of modeling used?