Data Warehouse Architect Interview Questions
26
Data Warehouse Architect interview questions shared by candidates
What's 5/2 in MySQL ?
4 Answers↳
2.5 is wrong according to MySpace
↳
may they expect it to be 2.5000 ?
↳
5/2 = 2 it will assume integer division
Write the sql for finding the two most populous cities per state in the two tables city and state.
1 Answers↳
A lot of questions involving group by's and having clauses.
Why TCS when you belong to Non CS IT field ?
1 Answers↳
Rather asking me , slap your stupid HR why he called me here.
Without the assistance of OEM, how would you ensure that temp space does not run out in the database
1 Answers↳
I would create an event based job using Oracle Scheduler
Why do you not have a Certication in <Vendor_name> Data Warehousing and Business Intelligence?
1 Answers↳
There was no mention of those as a requirement for this Position. In addion, I had been working for as a Prinicpal Consultant for over 10 years - before these courses were introduced. When I did enquire, I was informed, that a) They were NOT regarded as neccessary to my Career Improvement within , since I had long ago gone passed the Standard being Certified with Rea-world experience b) We are too busy to let in-demand Consultants go swanning off on Training Courses, until there is a brak in Projects. Less
Tell me about slowly changing dimensions. What are the 3 types of fact tables? Should you use a star schema or snowflake?
1 Answers↳
Slowly Changing Dimensions - These are the three different ways to handle historical data changes in a dimension table. There is Type 1 (Overwrite the value), Type 2 (Add a new row to the dimension table), and Type 3 (Add a dimension column). On whether to use a star schema or snowflake... the answer is "It depends" on whether you need (or want) to normalize the dimension table. A standard star schema will have both conformed dimensions, junk dimensions, (normal) subject area specific dimensions (relative to the grain of a fact table). Less
