Answer Posted / ravi katariya
types of dimensional table
type 1dimension
type 2dimension
type 3dimension
time dimension
srunk dimension
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How did you plan your Data ware house project?
Start a batches with in a batch?
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 the key columns in Fact and dimension tables?
Can you brief about the Data warehouse project you worked on?
Explain what is difference between query studio and report studio?
What is the function of surrogate key in data warehousing?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is a hash cluster?
What is application.cfm?
What are aggregate tables and aggregate fact tables?
Describe the differences between a data warehouse and data mart.
Explain Association algorithm in Data mining?
Explain me what are data marts?
What is execution plan?