What are the key features of chameleon that separates it from other algorithms?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain Association algorithm in Data mining?
Explain what is metadata reporter?
What is VLDB?
Whether dimension table can have numeric value?
What is surrogate key? Where we use it? Explain with examples.
What is Discrete and Continuous data in Data mining world?
Explain the importance of data warehouse?
Explain what is the advantages data mining over traditional approaches?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are parallel querys and query hints?
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?
Explain what are the advantages and disadvantages of reporting directly against the database?
What are data modeling and data mining?