- 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 Interview Questions & Answers - Learning Mode

Data Warehousing Interview Questions & Answers - Learning Mode

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. A data warehouse 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.

Try Data Warehousing Interview Questions & Answers - Exam Mode
Subcategories for Data Warehousing Interview Questions & Answers - Learning Mode

Following are sub categories for which Interview Questions & Answers are available under Data Warehousing Interview Questions & Answers - Learning Mode. Please select the appropriate sub-category:-

Abinitio Interview Questions & Answers (108) Learning Mode | Exam Mode

Analysis services Interview Questions & Answers (22) Learning Mode | Exam Mode

BO Designer Interview Questions & Answers (72) Learning Mode | Exam Mode

Business Intelligence Interview Questions & Answers (36) Learning Mode | Exam Mode

Business Objects Interview Questions & Answers (81) Learning Mode | Exam Mode

Cognos Interview Questions & Answers (54) Learning Mode | Exam Mode

Cold Fusion Interview Questions & Answers (20) Learning Mode | Exam Mode

Data Mart Interview Questions & Answers (12) Learning Mode | Exam Mode

Data Warehousing Basics Interview Questions & Answers (40) Learning Mode | Exam Mode

Data Warehousing Concepts Interview Questions & Answers (16) Learning Mode | Exam Mode

DataStage Interview Questions & Answers (178) Learning Mode | Exam Mode

Enterprise Data Warehouse Interview Questions & Answers (13) Learning Mode | Exam Mode

ETL Interview Questions & Answers (50) Learning Mode | Exam Mode

General Datawarehousing Interview Questions & Answers (50) Learning Mode | Exam Mode

Informatica Interview Questions & Answers (417) Learning Mode | Exam Mode

MicroStrategy Interview Questions & Answers (10) Learning Mode | Exam Mode

Operational Data Store Interview Questions & Answers (11) Learning Mode | Exam Mode

Reportnet Interview Questions & Answers (34) Learning Mode | Exam Mode

1 2 3 4 5 6 7 8 Next

Sort By : Latest First | Oldest First | By Rating

Data Warehousing Interview Questions & Answers - Learning Mode
Try Data Warehousing Interview Questions & Answers - Exam Mode
Question: What is a level of Granularity of a fact table?

Answer: A fact table is usually designed at a low level of Granularity. Source:
Question: what is project architecture in datastage

Answer: No answer available currently.
Question: What is the difference between OLAP and data warehouse?

Answer: Datawarehouse is the place where the data is stored for analyzing where as OLAP is the process of analyzing the data,managing aggregations, partitioning information into cubes for in depth visualization. Source:
Question: Explain about the top design?

Answer: In a top design model data ware house is designed in a normalized enterprise model. This is chiefly used for business intelligence and management capabilities. Data used for business purpose and management can be met through a dataware house. It is used to generate dimensional views and is known to be good and stable against business changes. Source:
Question: What are the general stages of use of dataware house?

Answer: These are the general stages of use: -
1) Offline operational database
2) Offline dataware house
3) Real time dataware house
4) Integrated dataware house. Source:
Question: What is Data warehousing Hierarchy?

Answer: 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 lower levels aggre Source:
Question: What is snapshot?

Answer: You can disconnect the report from the catalog to which it is attached by saving the report with a snapshot of the data. However, you must reconnect to the catalog if you want to refresh the data. Source:
Question: What is SCD1 , SCD2 , SCD3?

Answer: SCD Stands for Slowly changing dimensions.

SCD1: only maintained updated values.

Ex: a customer address modified we update existing record with new address.

SCD2: maintaining historical information and current information by using

A) Effective Date
B) Versions
C) Flags

or combination of these

SCD3: by adding new columns to target table we maintain historical information and current information. Source:
Question: What is a look up table?

Answer: A look up table is nothing but a 'look up' it give values to referenced table (it is a reference), it is used at the run time, it saves joins and space in terms of transformations. Example, a look up table called states, provide actual state name ('Texas') in place of TX to the output.
Question: Is it correct/feasible develop a Data Mart using an ODS?

Answer: The ODS is technically designed to be used as the feeder for the DW and other DM's , yes. It is to be the source of truth. Source:
Question: How can u recover the session in sequential batches?

Answer: If you configure a session in a sequential batch to stop on failure, you can run recovery starting with the failed session. The Informatica Server completes the session and
then runs the rest of the batch. Use the Perform Recovery session property
To recover sessions in sequential batches configured to stop on failure:
1.In the Server Manager, open the session property sheet.
2.On the Log Files tab, select Perform Recovery, and click OK.
3.Run the session.
4.After the batch com Source:
Question: Why should you put your data warehouse on a different system than your OLTP system?

Answer: A OLTP system is basically " data oriented " (ER model) and not " Subject oriented "(Dimensional Model) .That is why we design a separate system that will have a subject oriented OLAP system...
Moreover if a complex querry is fired on a OLTP system will cause a heavy overhead on the OLTP server that will affect the daytoday business directly.
Question: What are the possible data marts in Retail sales.?

Answer: Product information,sales information Source:
Question: What are slowly changing dimensions (SCD)?

Answer: 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 the original record. Only one record exist in database ? current data.
2) SCD2 : A new record is added into the customer dimension table. Two records exist in database ? current data and previous history data.
3) SCD3 : The original data is modified to include new data. One record exist in Source:
Question: Explain in brief about critical column.

Answer: A column (usually granular) is called as critical column which changes the values over a period of time.

For example, there is a customer by name ?Anirudh? who resided in Bangalore for 4 years and shifted to Pune. Being in Bangalore, he purchased Rs. 30 Lakhs worth of purchases. Now the change is the CITY in the data warehouse and the purchases now will shown in the city Pune only. This kind of process makes data warehouse inconsistent. In this example, the CITY is the critical column. Su Source:
Question: What is the difference between data warehousing and business intelligence?

Answer: Data warehousing deals with all aspects of managing the development, implementation and operation of a data warehouse or data mart including meta data management, data acquisition, data cleansing, data transformation, storage management, data distribution, data archiving, operational reporting, analytical reporting, security management, backup/recovery planning, etc. Business intelligence, on the other hand, is a set of software tools that enable an organization to analyze measurable aspects of Source:
Question: Can a dimension table contains numeric values?

Answer: yes we can have numeric values in dimensional table but these are not frequently updated as dim table contains constant data but only on some occassions it can change. Source:
Question: What is a data mart?

Answer: A data mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes complete individual data warehouses which are usually smaller than the corporate data warehouse. Source:
Question: How much data hold in one universe.

Answer: Universe does not hold any data. However, practically the universe is known to have issues when the objects cross 6000.
Question: What do you know about Datawarehousing ?

Answer: Data warehousing is used for reporting and analysis of the data. It is primarily used to analyze data. Some of the additional uses of it are extraction and retrieval of data, manage, load and manipulate data. It has various tools which can transform, load, extract and manage the data. Source:

1 2 3 4 5 6 7 8 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.058594 Seconds