What is a Data Warehouse?
- 9 Answers
- 10712 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / p.d.vijay kumar
a datawarehouse is a subject oriented,integrated,time varient
collection of data in support of management's decision
making process
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / siri
data warehouse is a subject oriented(which deals with
particular area of business),integrated(combine data in
data bases),time variant(depends on regularity),non
volatile(static or read only)collection of data which is
helpful in decision making.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anil reddy,bang
a datawarehouse is a subject oriented,integrated,time
varient and non voltain.
collection of data in support for taking decision
making process
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravi v
Collection of operational databases and which is used to
maintain the historical data for to take the effective
decisions in business. It is a non volatile data, it is
also called as DSS (decision support system) and Read only
data.
| Is This Answer Correct ? | 1 Yes | 0 No |
DATA WARE HOUSE IS A COLLECTION OF DATA IS USED FOR
BUSINESS OPERATIONS.
Eg: BANKING,HEALTH CARE,INSURANCE,AND TELE COMMUNICATIONS
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nethaji
Data warehouse is a technology used for analyzing data for
managements decision support needs.Data from various sources
are integrated into a single source.Data in the
warehouse is nonvolatile.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raji
Data warehouse is logical database,which is maintain
different mutlipule databases and stored historical data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vijay bhaskar
Data warehouse is integrated,subject oriented,time
oriented,non olatile collection of data to the
decisionmaking system
| Is This Answer Correct ? | 0 Yes | 0 No |
How many types of facts and what are they?
Can decision tree be implemented using SQL?
Explain what are the various file formats involved in reportnet?
Explain what are slowly changing dimensions?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
How to join 3 database like flat file, oracle, db2 in informatrica?
Is there any difference in testing database and data ware housing?
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 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What are situations where snowflake schema is better than star schema when the opposite is true?
Describe the differences between a data warehouse and data mart.
How can we run the graph? How can we schedule the graph in unix?
Teradata 
