Depending on who's doing the interview and how serious they are:
-Describe advantages of the CIF architecture versus the bus architecture with conformed dimensions. Which would fit best in our environment given [some parameters they give you] and why
-Describe snowflaking
-Describe factless fact tables.
-Draw a star schema of our business
-Describe common optimization techniques applied at the data model level
-How do you handle data rejects in a warehouse architecture?
-Describe common techniques for loading from the staging area to the warehouse when you only have a small window.
-How do you load type 1 dimensions
-How do you load type 2 dimensions, and how would you load it given our [insert business particularity]
-How would you model unbalanced hierarchies
-How would you model cyclic relations
-What major elements would you include in an audit model?
-How would you implement traceability?
etc...
Edit: If they focus on your SQL Server expertise they don't know what they are doing. If you can't answer all of the above in great details you might still get the job but you're in danger in creating some form of data dump that people often call warehouse which needs to be replaced early on (It's ok, it gives me a job
)
If needed, I can recommend all the necessary reading.
-Describe advantages of the CIF architecture versus the bus architecture with conformed dimensions. Which would fit best in our environment given [some parameters they give you] and why
-Describe snowflaking
-Describe factless fact tables.
-Draw a star schema of our business
-Describe common optimization techniques applied at the data model level
-How do you handle data rejects in a warehouse architecture?
-Describe common techniques for loading from the staging area to the warehouse when you only have a small window.
-How do you load type 1 dimensions
-How do you load type 2 dimensions, and how would you load it given our [insert business particularity]
-How would you model unbalanced hierarchies
-How would you model cyclic relations
-What major elements would you include in an audit model?
-How would you implement traceability?
etc...
Edit: If they focus on your SQL Server expertise they don't know what they are doing. If you can't answer all of the above in great details you might still get the job but you're in danger in creating some form of data dump that people often call warehouse which needs to be replaced early on (It's ok, it gives me a job
)If needed, I can recommend all the necessary reading.
No comments:
Post a Comment