If someone wants to become a DW Architect, there is a lot of knowledge required. Some of the different perspectives (one from MS not specifically for DW, rather enterprise) and another on DW specifically..
Although I think its strange already that someone has to think about the kind of questions being asked in such interview, there are things posted on these lines. i believe its more of a discussion on thought process and approach rather than question-answer session in such an interview. Still, presenting an excerpt, outlining some of the interesting topics that might turn up in a discussion for this kind of position.
- 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 snow-flaking
- Describe fact-less 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 trace-ability ?
Questions picked up from http://arstechnica.com/civis/viewtopic.php?f=20&t=320772
One of the Microsoft guys wrote about possible feathers in the cap of an Enterprise Architect - http://blogs.msdn.com/b/nickmalik/archive/2006/09/09/ea-interviews.aspx
You are providing good knowledge. It is really helpful and factual information for us and everyone to increase knowledge. about Household Storage Solution .Continue sharing your data. Thank you.
ReplyDelete