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
Great Article
ReplyDeleteData Mining Projects IEEE for CSE
Project Centers in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
In the nutshell, information driven methodologies is on wheels overwhelming the whole range.data science course in pune
ReplyDeleteI think this is one of the most significant information for me. And i’m glad reading your article. But should remark on some general things, architects in essex
ReplyDelete
ReplyDeleteSuch a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. I would like to state about something which creates curiosity in knowing more about it. It is a part of our daily routine life which we usually don`t notice in all the things which turns the dreams in to real experiences. Back from the ages, we have been growing and world is evolving at a pace lying on the shoulder of technology. data science course will be a great piece added to the term technology. Cheer for more ideas & innovation which are part of evolution.
Glad to chat your blog, I seem to be forward to more reliable articles and I think we all wish to thank so many good articles, blog to share with us.
ReplyDeleteData Analytics Course in Mumbai
I will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more.
ReplyDeleteExcelR Data Analytics courses
I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.
ReplyDeletedata analytics course in hyderabad
You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog.
ReplyDeleteExcelR Courses in Business Analytics
The information provided on the site is informative. Looking forward more such blogs. Thanks for sharing .
ReplyDeleteArtificial Inteligence course in Nashik
AI Course in Nashik
Attend The Course in Data Analytics From ExcelR. Practical Course in Data Analytics Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Course in Data Analytics.
ReplyDeleteCourse in Data Analytics
Data Science Interview Questions
This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
ReplyDeleteSimple Linear Regression
ReplyDeleteGreat information!! Thanks for sharing nice blog.
Data Science Course in Hyderabad
I am really happy with your blog because your article is very unique and powerful for new reader.data science course in Hyderabad
ReplyDeleteHowever, it is used to structure data, look for compelling patterns and advise decision-makers so that they can revolutionize business needs. data science course syllabus
ReplyDeleteFor the best deal (Shhhh…. Something special we are talking about) for desert safari tour, Contact Us. You can mail us or call us. We have some special offer running for a limited period of time. Avail your discount today!
ReplyDeletevisit us:-Desert Safari Dubai
Morning Desert Safari Dubai
We cannot even come up with a perfect definition for intelligence, yet we are already on our way to build several of them. data science course in india
ReplyDelete
ReplyDeleteJust the way I have expected. Your website really is interesting. ExcelR Data Analytics Course
Excellent read, I just passed this on to a colleague who was doing some research about it. He has already bought me lunch because I found a smile on him so let me rephrase that. dubai dune buggy tours
ReplyDeleteReally nice and interesting post. I was looking for this kind of information and enjoyed reading this one.
ReplyDeletedata analytics course in hyderabad
yeni perde modelleri
ReplyDeletesms onay
MOBİL ÖDEME BOZDURMA
nft nasil alinir
ankara evden eve nakliyat
trafik sigortası
dedektör
Web site kurma
aşk kitapları
SMM PANEL
ReplyDeleteSmm Panel
iş ilanları
İnstagram takipçi satın al
HÄ°RDAVATCÄ°
BEYAZESYATEKNÄ°KSERVÄ°SÄ°.COM.TR
servis
tiktok jeton hilesi
Really nice and interesting post. I was looking for this kind of information and it was great to read it. Keep posting. Thanks for sharing 😊😊😊😊😊Sometimes travelers get overwhelmed by the complicated procedures of visa acquisition. However, getting e-visa to Turkey from Indian is as easy as making a paper plane : ) Apply Turkey visa for Indian passport with the online portal and get your e-visa in 3 steps!
ReplyDeleteThis blog is my go-to source for inspiration and enlightenment! The thoughtful analysis and expertly crafted content never fail to impress me. To check the status of your Saudi Arabia visa online check, visit the official visa portal and navigate to the designated section for visa inquiries. Enter your application details as prompted to track the progress of your e-visa processing.
ReplyDeleteI regularly engage in blogging, and your content consistently impresses me. Your latest article has certainly captured my interest. I've taken the step to bookmark your website so I can stay informed about your new posts, which I usually do on a weekly basis. Additionally, I've subscribed to your RSS feed. "Azerbaijan visa for Indian GCC residents is accessible with ease. GCC residents can apply online, requiring passport copies, photos, and GCC residency proof for a smooth visa process."
ReplyDeleteI'm continually inspired by the depth and breadth of topics covered on your blog. Your thoughtful analysis and engaging writing style make complex subjects accessible and engaging. How to apply Saudi visit visa from Australia ?To apply for a Saudi visit e-visa from Australia, visit our page . Complete the online application form, submit required documents such as passport details and itinerary, and follow the outlined procedures for processing.
ReplyDeleteYour blog post takes readers on a literary exploration seamlessly navigating the territories of intellect and emotion. The harmonious integration of profound insights and relatable anecdotes is genuinely impressive. Is Vietnam visa-free for Indian? At present, Vietnam does not extend visa-free access to Indian nationals. Indians must secure an Visa prior to their Vietnam trip. Compliance with all prerequisites is imperative for a hassle-free travel journey.
ReplyDelete