CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
Data Warehousing Basics Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS DATA WAREHOUSING BASICS INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

Data Warehousing Basics Interview Questions & Answers - Learning Mode

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis. Data warehousing is the process of constructing and using a data warehouse. A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making.

Try Data Warehousing Basics Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Data Warehousing Basics Interview Questions & Answers - Learning Mode
Try Data Warehousing Basics Interview Questions & Answers - Exam Mode
Question: What is the difference between view and materialized view?



Answer: View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.

Materialized view - stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Pros include quick query results.

Source: CoolInterview.com
Question: What is Dimensional Modelling



Answer: Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measuremnets ie, the dimensions on which the facts are calculated. Source: CoolInterview.com
Question: What is BUS Schema?




Answer: BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts. Source: CoolInterview.com
Question: What is a Fact,Dimension,Measure?

Answer: Fact is key performance indicator to analyze the business.Dimension is used to analyze the fact.Without dimension there is no meaning for fact. Source: CoolInterview.com
Question: Why fact table is in normal form?



Answer: Basically the fact table consists of the Index keys of the dimension/ook up tables and the measures.

so when ever we have the keys in a table .that itself implies that the table is in the normal form.

Source: CoolInterview.com
Question: What is hybrid slowly changing dimension



Answer: Hybrid SCDs are combination of both SCD 1 and SCD 2.

It may happen that in a table, some columns are important and we need to track changes for them i.e capture the historical data for them whereas in some columns even if the data changes, we don't care.

For such tables we implement Hybrid SCDs, where in some columns are Type 1 and some are Type 2.
Source: CoolInterview.com
Question: What is conformed fact?



Answer: Conformed dimensions are the dimensions which can be used across multiple Data Marts in combination with multiple facts tables accordingly

Source: CoolInterview.com
Question: can a dimension table contains numeric values?



Answer: Yes.But those datatype will be char (only the values can numeric/char)


Source: CoolInterview.com
Question: what is junk dimension?
what is the difference between junk dimension and degenerated dimension?



Answer: Junk dimension: Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension.


Degenerate Dimension: Keeping the control information on Fact table ex: Consider a Dimension table with fields like order number and order line number and have 1:1 relationship with Fact table, In this case this dimension is removed and the order information will be directly stored in a Fact table inorder eliminate unneccessary joins while retrieving order informat Source: CoolInterview.com
Question: What is the data type of the surrogate key?



Answer: Data type of the surrogate key is either integer or numeric or number
Source: CoolInterview.com
Question: What is Data warehosuing Hierarchy?



Answer: Hierarchies
Hierarchies are logical structures that use ordered levels as a means of organizing data. A hierarchy can be used to define data aggregation. For example, in a time dimension, a hierarchy might aggregate data from the month level to the quarter level to the year level. A hierarchy can also be used to define a navigational drill path and to establish a family structure.

Within a hierarchy, each level is logically connected to the levels above and below it. Data values at low Source: CoolInterview.com
Question: What are the possible data marts in Retail sales.?



Answer: Product information,sales information Source: CoolInterview.com
Question: Wht r the data types present in bo?n wht happens if we implement view in the designer n report



Answer: Three different data types: Dimensions,Measure and Detail.

View is nothing but an alias and it can be used to resolve the loops in the universe.
Source: CoolInterview.com
Question: What is data validation strategies for data mart validation after loading process



Answer: Data validation is to make sure that the loaded data is accurate and meets the business requriments.

Strategies are different methods followed to meet the validation requriments
Source: CoolInterview.com
Question: What is the datatype of the surrogate key?



Answer: Datatype of the surrogate key is either integer or numeric or number.<br> Source: CoolInterview.com
Question: What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?



Answer: RDBMS Schema
* Used for OLTP systems
* Traditional and old schema
* Normalized
* Difficult to understand and navigate
* Cannot solve extract and complex problems
* Poorly modelled

DWH Schema
* Used for OLAP systems
* New generation schema
* De Normalized
* Easy to understand and navigate
* Extract and complex problems can be easily solved
* Very good model Source: CoolInterview.com
Question: Differences between star and snowflake schemas



Answer: Star schema

A single fact table with N number of Dimension



Snowflake schema

Any dimensions with extended dimensions are know as snowflake schema


Source: CoolInterview.com
Question: What are the advantages data mining over traditional approaches?



Answer: Data Mining is used for the estimation of future. For example, if we take a company/business organization, by using the concept of Data Mining, we can predict the future of business interms of Revenue (or) Employees (or) Cutomers (or) Orders etc.

Traditional approches use simple algorithms for estimating the future. But, it does not give accurate results when compared to Data Mining.
Source: CoolInterview.com
Question: What are the different architecture of datawarehouse



Answer: I think, there are two main things

1. Top down - (bill Inmon)

2.Bottom up - (Ralph kimbol)

Source: CoolInterview.com
Question: What is Difference between E-R Modeling and Dimentional Modeling.



Answer: Basic diff is E-R modeling will have logical and physical model. Dimensional model will have only physical model.

E-R modeling is used for normalizing the OLTP database design.

Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.
Source: CoolInterview.com

1 2 Next



India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.046875 Seconds