Data Warehousing Interview Questions – Part1

CareerShapers

1. What is a Datawarehouse?

Ans. A datawarehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision making process.

Subject-Oriented: A data warehouse can be used to analyze a particular subject area. For example, “sales” can be a particular subject.

Integrated: A data warehouse integrates data from multiple data sources. For example, source A and source B may have different ways of identifying a product, but in a data warehouse, there will be only a single way of identifying a product.

Time-Variant: Historical data is kept in a data warehouse. For example, one can retrieve data from 3 months, 6 months, 12 months, or even older data from a data warehouse. This contrasts with a transactions system, where often only the most recent data is kept. For example, a transaction system may hold the most recent address of a customer, where a…

View original post 1,091 more words

Advertisements

About Jamberry Nails with Amy

A data geek at heart with fabulous nails! Please join me in enjoying Jamberry Nails. As a consultant I would love to work with you and spread the fun!

One response to “Data Warehousing Interview Questions – Part1”

  1. CareerShapers says :

    Hey Amy,

    Thanks for the reblog. 🙂

    We are coming up with a dedicated section on Data-Mining, Business Intelligence and Business Analytics. U can follow our blog to keep yourself updated.
    Keep Visiting!!

    Happy Reading
    Team CareerShapers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Hip2Save

Not Your Grandma's Coupon Site

BI Corner

At the intersection of Business Intelligence & Analytics

Data and Analytics with Dustin Ryan

Dustin Ryan is a Data Platform Solutions Architect with Microsoft interested in Azure, SQL Server, and Power BI.

Data Visualization

Discover, Analyze, Explore, Pivot, Drilldown, Visualize your data... “How do I know what I think until I see what I say?” [E.M. Forster, G. Wallas, A. Gide]

Data Science 101

Learning To Be A Data Scientist

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

FiveThirtyEight

Nate Silver’s FiveThirtyEight uses statistical analysis — hard numbers — to tell compelling stories about politics, sports, science, economics and culture.

VizCandy

All Data and BI

citizenintelligence

The business blog

Dave Alper: Business Intelligence and Data Visualization

Lessons Learn from 20+ Years in the Trenches

Live, Nerd, Repeat

Making life better through the perfect application of humor and nerdery

digiphile

We're already living in the future. It's just not evenly distrbuted yet.

The Daily Post

The Art and Craft of Blogging

NFL.com Blogs

Official Blog of the National Football League

SNF All Access

Behind the scenes access into the world of Sunday Night Football

%d bloggers like this: