Click here to get free chapters (PDF) in the mailbox It was a great pleasure to write latest series about Data Warehousing Interview Questions and Answers. Just like always again, I received lots of suggestion and follow up questions. I have tried to accommodate all of them in the last…Read More
Click here to get free chapters (PDF) in the mailbox What are slowly changing dimensions (SCD)? SCD is abbreviation of Slowly changing dimensions. SCD applies to cases where the attribute for a record varies over time. There are three different types of SCD. 1) SCD1 : The new record replaces…Read More
Click here to get free chapters (PDF) in the mailbox What are normalization forms? Please visit this article. Describes the foreign key columns in fact table and dimension table? Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of facts tables are primary keys of Dimension…Read More
Let us learn about Data Warehousing Interview Questions and Answers.
Click here to get free chapters (PDF) in the mailbox This series is in response to many of my reader’s continuous request to start Data Warehousing Interview Questions and Answers series. This series is written in the same spirit as previous two series which has received good response. Samples Question…Read More
Few of the questions I receive very frequently. I have collect them in spreadsheet and try to answer them frequently. How to convert text to integer in SQL? If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or…Read More
In recent interview sessions in hiring process I asked this question to every prospect who said they know basic SQL. Surprisingly, none answered me correct. They knew lots of things in details but not this simple one. One prospect said he does not know cause it is not on this…Read More