Intel Corporation Data Warehouse Architect/Modeler Interview Questions

Notifications

Intel Corporation

19 Apr 2012

Anonymous employee

Accepted offer

Positive experience

Average interview

Application

The process took 1 day. I interviewed at Intel Corporation in Jun 2011

Interview

Questions on Dimensional modeling and Kimball's Methodology. Normalization; slowly changing dimensions, fact tables.

Interview questions [2]

Question 1

What is 3rd normal form and why use it? What is the Kimball methodology?

Question 2

Tell me about slowly changing dimensions. What are the 3 types of fact tables? Should you use a star schema or snowflake?