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 Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS 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 are the major differences between Informatica 7.1,8.1,8.5 and 8.6?

Answer: 8.1 supports java transformation and service oriented architecture rather than 7.1. Source: CoolInterview.com
Question: What is active data warehousing?

Answer: An active data warehouse provides information that enables decision-makers within an organization to manage customer relationships nimbly, efficiently and proactively. Active data warehousing is all about integrating advanced decision support with day-to-day-even minute-to-minute-decision making in a way that increases quality of those customer touches which encourages customer loyalty and thus secure an organization's bottom line. The marketplace is coming of age as we progress from first-g Source: CoolInterview.com
Question: What is data cleaning? How can we do that?

Answer: 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:

► Missing information for a column from one of the data sources;
► Inconsistent information among different data sources;
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. Source: CoolInterview.com
Question: What is degenerate dimension table?

Answer: Degenerate Dimensions: If a table contains the values, which r neither dimension nor measures is called degenerate dimensions. For example invoice id, employee no.A degenerate dimension is data that is dimensional in nature but stored in a fact table. Source: CoolInterview.com
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: CoolInterview.com
Question: Data Warehousing - Introduction

Answer: 1. Explain the evolution of database technology to data mining 2 to 5
2. Describe the steps involved in data mining as a process of knowledge discovery 11 to
3. How is a data warehouse different from a database? How are they similar?
4. Briefly describe different advance database systems and their applications.
5. Define different data mining functionalities 53 to 72
6. Define interestingness, and explain the issues related to interestingness 73 to 78
7. Explain the classificat Source: CoolInterview.com
Question: Why is SAS so popular?

Answer: Statistical Analysis System is an integration of various software products which allows the developers to perform
Data entry, data retrieval, data management and data mining
Report writing and supports for graphics
Statistical analysis, business planning, business forecasting and business decision support
Operations research and project management, quality improvement, application development
Extract, transform and load functions in data warehousing.
Platform independent and re Source: CoolInterview.com
Question: What is a Star Schema?


Answer: Star schema is a type of organizing the tables such that we can retrieve the result from the database quickly in the warehouse environment. Source: CoolInterview.com
Question: Which is the optimized method of extracting the data?

Answer: Delta loading is a way to extract data in a optimized way. Doing the incremental load by tracking the last update date or modified date makes the ETL processing faster. Source: CoolInterview.com
Question: What are aggregations?

Answer: Aggregations are precalculated numeric data. By calculating and storing the answers to a query before users ask for it, the query processing time can be reduced. This is key in providing fast query performance in OLAP. Source: CoolInterview.com
Question: What is ODS?

Answer: 1. ODS means Operational Data Store.
2. A collection of operation or bases data that is extracted from operation databases and standardized, cleansed, consolidated, transformed, and loaded into an enterprise data architecture. An ODS is used to support data mining of operational data, or as the store for base data that is summarized for a data warehouse. The ODS may also be used to audit the data warehouse to assure summarized and derived data is calculated properly. The ODS may further becom Source: CoolInterview.com
Question: Can u copy the session to a different folder or repository?

Answer: In addition, you can copy the workflow from the Repository manager. This will automatically copy the mapping, associated source,targets and session to the target folder.
Discuss the advantages & Disadvantages of star & snowflake schema?
In a STAR schema there is no relation between any two dimension tables, whereas in a SNOWFLAKE schema there is a possible relation between the dimension tables. Source: CoolInterview.com
Question: What are the types of External Loader available with Informatica?

Answer: If you have rank index for top 10. However if you pass only 5 records, what will be the output of such a Rank Transformation?
if u r using a update strategy in any of ur mapping, then in session properties u have to set treat source rows as Data Driven. if u select insert or udate or delete, then the info server will not consider UPD for performing any DB operations.

ELSE

u can use the UPD session level options. instead of using a UPD in mapping just select the update in treat s Source: CoolInterview.com
Question: What is difference between stored procedure transformation and external procedure transformation?

Answer: In case of storedprocedure transformation procedure will be compiled and executed in a relational data source.U need data base connection to import the stored procedure
in to u?r maping.Where as in external procedure transformation procedure or function will be executed out side of data source.Ie u need to make it as a DLL to access in u r
maping.No need to have data base connection in case of external procedure transformation Source: CoolInterview.com
Question: How to use mapping parameters and what is their use

Answer: In designer u will find the mapping parameters and variables options.u can assign a value to them in designer. comming to there uses suppose u r doing incremental extractions daily. suppose ur source system contains the day column. so every day u have to go to that mapping and change the day so that the particular data will be extracted . if we do that it will be like a layman's work. there comes the concept of mapping parameters and variables. once if u assign a value to a mapping variable Source: CoolInterview.com
Question: What is Data Mart?

Answer:
A data mart (DM) is a specialized version of a data warehouse (DW). Like data warehouses, data marts contain a snapshot of operational data that helps business people to strategize based on analyses of past trends and experiences. The key difference is that the creation of a data mart is predicated on a specific, predefined need for a certain grouping and configuration of select data. A data mart configuration emphasizes easy access to relevant information (Reference : Wiki). Data Marts are Source: CoolInterview.com
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: CoolInterview.com
Question: What are the different interconnected layers of a dataware house?

Answer: There are four different interconnected layers they are: -
? Operational database layer
? Informational access layer
? Data access layer
? Meta data layer.
Source: CoolInterview.com
Question:
What is active data warehousing?


Answer:
An active data warehouse provides information that enables decision-makers within an organization to manage customer relationships nimbly, efficiently and proactively. Source: CoolInterview.com

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.027344 Seconds