Wednesday, July 14, 2010

Trying to become a Data warehousing architect... !!!




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.

  1. 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
  2. Describe snow-flaking
  3. Describe fact-less fact tables.
  4. Draw a star schema of our business
  5. Describe common optimization techniques applied at the data model level
  6. How do you handle data rejects in a warehouse architecture?
  7. Describe common techniques for loading from the staging area to the warehouse when you only have a small window.
  8. How do you load type 1 dimensions
  9. How do you load type 2 dimensions, and how would you load it given our [insert business particularity]
  10. How would you model unbalanced hierarchies
  11. How would you model cyclic relations
  12. What major elements would you include in an audit model?
  13. How would you implement trace-ability ?

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



26 comments:

  1. In the nutshell, information driven methodologies is on wheels overwhelming the whole range.data science course in pune

    ReplyDelete
  2. I 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

  3. Such 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.

    ReplyDelete
  4. 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.

    Data Analytics Course in Mumbai

    ReplyDelete
  5. 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.
    ExcelR Data Analytics courses

    ReplyDelete
  6. I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.
    data analytics course in hyderabad

    ReplyDelete
  7. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog.
    ExcelR Courses in Business Analytics

    ReplyDelete
  8. The information provided on the site is informative. Looking forward more such blogs. Thanks for sharing .
    Artificial Inteligence course in Nashik
    AI Course in Nashik

    ReplyDelete
  9. 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.
    Course in Data Analytics
    Data Science Interview Questions

    ReplyDelete
  10. 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.

    Simple Linear Regression

    ReplyDelete
  11. I am really happy with your blog because your article is very unique and powerful for new reader.data science course in Hyderabad

    ReplyDelete
  12. However, 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

    ReplyDelete
  13. For 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!



    visit us:-Desert Safari Dubai
    Morning Desert Safari Dubai

    ReplyDelete
  14. 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

  15. Just the way I have expected. Your website really is interesting. ExcelR Data Analytics Course

    ReplyDelete
  16. 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

    ReplyDelete
  17. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one.
    data analytics course in hyderabad

    ReplyDelete
  18. 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!

    ReplyDelete
  19. This 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.

    ReplyDelete
  20. I 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."

    ReplyDelete
  21. I'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.

    ReplyDelete
  22. Your 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