Warm greetings !
I'm very happy to post some interview questions today which I'd faced recently via a Skype.
Could you please help me to note down the answers ?
Question 1 :
Using SQL Server 2012 features build two select statements that will calculate the difference in sales between a month end and the last and next month values.
Please use pseudocode if uncertain of exact syntax.
Question 2 :
What are row and column store indexes, explain ?
Question 3 :
Build a SSIS diagram / pseudo code showing the steps with comments from a raw data in a CSV format to a fact table in a data warehouse.
The process needs to cope with the dimension data that may not be in the dimension tables ?