Data Warehousing Interview Questions And Answers Guide

Data Warehousing Interview
Questions And Answers Guide.




Global Guideline.
http://www.globalguideline.com/

, Data Warehousing Interview Questions And Answers




G
Data Warehousing Job Interview Preparation Guide.
lo
ba
lG
Question # 1
What is Meta data?
ui
Answer:-
Metadata is data about data. E.g. if in data mart we are receiving any file. Then metadata will contain information like how many columns, file is fix width/limited,
ordering of fields, data types of field etc.
d
Read More Answers.
el
Question # 2
Briefly state different between data ware house & data mart?
in
Answer:-
Data warehouse is made up of many datamarts. DWH contain many subject areas. However, data mart focuses on one subject area generally. E.g. If there will be
DHW of bank then there can be one data mart for accounts, one for Loans etc. This is high-level definitions.
e
Read More Answers.


Question # 3
.C
What is galaxy schema?
Answer:-
Galaxy schema is also known as fact constellation scheme. It requires no of fact tables to share dimension tables. In data, wares housing mainly the people are using
the conceptual hierarchy.
O
Read More Answers.
M
Question # 4
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet
the condition.
Answer:-
Informatica filter transformation default value is 1 i.e. true. If you place a break point on filter transformation and run the mapping in a debugger mode, you will find
these values 1 or 0 for each row passing through filter. If you change 0 to 1, the particular row will be passed to next stage.
Read More Answers.


Question # 5
After we create a SCD table, can we use that particular Dimension as a dimension table for Star Schema?
Answer:-
Yes.
Read More Answers.


Question # 6
What is Core Dimension?
Answer:-
Core Dimension is a Dimension table, which is used dedicated for single fact table or Datamart. Conform Dimension is a Dimension table which is used across fact
tables or Data marts.
Read More Answers.


Question # 7
How much data hold in one universe.
Answer:-

Copyright © http://www.GlobalGuideline.COM Page 2/19

, Data Warehousing Interview Questions And Answers


Universe does not hold any data. However, practically the universe is known to have issues when the objects cross 6000.
Read More Answers.


Question # 8
Can any one explain about Core Dimension, Balanced Dimension, and Dirty Dimension?
Answer:-
G
Dirty Dimension is nothing but Junk Dimensions. Core Dimensions are dedicated for a fact table or Data mart. Conformed Dimensions are used across fact tables or
Data marts.
Read More Answers.
lo
Question # 9
ba
Can any one explain the Hierarchies level Data warehousing.
Answer:-
In Data warehousing, levels are columns available in dimension table. Levels are having attributes. Hierarchies are used for navigational purpose; there are two types
of Hierarchies. You can define hierarchies in top down or bottom up.
lG
1. Natural Hierarchy: Best example is Time Dimension - Year, Month, Day etc. In natural Hierarchy definite relationship exists between each level
2. Navigational Hierarchy: You can have levels like
Ex - Production cost of Product, Sales Cost of Product.
Ex - Lead Time defined to procure, Actual Procurement time,
In this, two levels need not to have relationship. This Hierarchy is created for navigational purpose.
ui
Read More Answers.


Question # 10
d
What is data cleaning? How can we do that?
Answer:-
el
Data cleaning is a self-explanatory term. Most of the data warehouses in the world source data from multiple systems - systems that were created long before data
warehousing was well understood, and hence without the vision to consolidate the same in a single repository of information. In such a scenario, the possibilities of
the following are there:
in
* Missing information for a column from one of the data sources;
* Inconsistent information among different data sources;
* Orphan records;
* Outlier data points;
e
* Different data types for the same information among various data sources, leading to improper conversion;
* Data breaching business rules
In order to ensure that the data warehouse is not infected by any of these discrepancies, it is important to cleanse the data using a set of business rules, before it makes
.C
its way into the data warehouse.
Read More Answers.


Question # 11
O
What is dimension modeling?
Answer:-
M
A logical design technique that seeks to present the data in a standard, intuitive framework that allows for high-performance access. There are different data modeling
concepts like ER Modeling (Entity Relationship modeling), DM (Dimensional modeling), Hierarchal Modeling, Network modeling. However, popular are ER and
DM only.
Read More Answers.


Question # 12
Where the cache files stored?
Answer:-
Caches are stored in Repository.
Read More Answers.


Question # 13
How can you import tables from a database?
Answer:-
In Business Objects Universe Designer you can open Table Browser and select the tables needed then insert them to designer.
Read More Answers.


Question # 14
What is drilling across?
Answer:-
Drill across corresponds to switching from 1 classification in 1 dimension to a different classification in different dimension.
Read More Answers.


Question # 15

Copyright © http://www.GlobalGuideline.COM Page 3/19