4.Explain Snowflkeschema ?
Answer Posted / sanjeev_mis
One dimension is not connected directly to the fact table, instead, it is connected through another dimension table.
... SANJEEV SHARMA
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is dimensional modelling?
How can we run the graph? How can we schedule the graph in unix?
Explain difference between data ware house & data mart?
Tell me what is degree of a relation?
What are the approaches used by optimizer during execution plan?
How to import vsam files from source to target. Do we need a special plugin?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain the difference between data ware house & data mart?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What are session timeout and application timeout? Where we have to do this process?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain what is difference between query studio and report studio?
what is user variable in affinium campaign? and some real time examples.
Explain the differences between normalizer and normalizer transformation?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?