-
What are the types of dimension tables
nareshcnr
- Nov 6th, 2017
Types of Dimension tables : There are mainly three types of dimension tables available in case of Slowly Changing Dimensions Type 1: Never maintain historical data. only update the existing data. e...
Johnny
- Aug 31st, 2017
The following are the type of dimensions
Slowly changing
Fast Changing
Inferred
Junk
Conformed
Degenerate, and
Static -
Fact and dimensions
Which type of relation between fact and dimension table in star schema and snowflake schema?like one to one or many to many?
naveen
- Dec 16th, 2014
Parent, child relation between fact,dimensions in star schema,snow flake schema
vveeralapati
- Apr 25th, 2013
For one dimension record, you will see many fact records associated.Many to one or one to many relationship is not to be confused with number of records or columns in a table. that has nothing to do with a relation
-
Database Design
Explain why database design is important?
LiamWhales
- Mar 24th, 2014
Database design is the key to a successful database. It reduces the amount of redundant data within the database along with correctly sized columns for minimal space usage whilst ensuring longevity. W...
Sheraz Baig
- Nov 25th, 2013
Database Design is the document which shows the flow of data, its functionality and relationship between tables. This document is very important during database development period , and after the comp...
-
-
What is the difference between aggregate table and materliazed view?
Read Best Answer
Editorial / Best Answer
joshmohit- Member Since Oct-2010 | Nov 3rd, 2010
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the database specific properties which might not be covered with the generic definition of aggregate tables.
Tom Haughey
- Apr 30th, 2012
?An aggregate table is a table that contains data that is summarized somehow, for example, it contains a summary of Customer by Product by Week. A more granular level of detail would be the transactio...
joshmohit
- Nov 3rd, 2010
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the...
-
Kimball and Inmon
How anyone define the pracical difference between Kimball & Inmon?
Read Best Answer
Editorial / Best Answer
shashk- Member Since Jul-2010 | Aug 25th, 2010
Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form.
Ralph Kimball's paradigm: Data warehouse is the conglomerate of all data marts within the enterprise. Information is always stored in the dimensional model.There is no right or wrong between these two ideas, as they represent different data warehousing philosophies.
In reality, the data warehouse in most enterprises are closer to Ralph Kimball's idea. This is because most data warehouses started out as a departmental effort, and hence they originated as a data mart. Only when more data marts are built later do they evolve into a data warehouse.shashk
- Aug 25th, 2010
Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse...
-
AutoSys Jobs Schedule
How can we schedule our jobs in third party tool - AutoSys?
saigarneni
- May 18th, 2010
We need to write shell script to run the job and write JIL on autosys to schedule the job
varghesebinu
- Dec 10th, 2009
Autosys is a total job scheduling solution that allows you to define the event dependencies, time schedules alerts etc making it a complete data center automation tool. An AutoSys job is any single co...
-
What is the difference between database and data warehousing?What is the main advantages of data warehousingWhat is mean by data stageWhat is the famous tools used for data warehousing?What is the architecture of data warehouisng model?
brahmiii
- Feb 28th, 2010
Database is the root of any data releted operations where as datawarehousing is a schema or process how effectively we access or utilize a database. Datawarehousing follows the star schema and snowflake schema as its basic schemas and we two other schemas also which are not much important.
sap_23
- Sep 3rd, 2009
Database: A database is used to record, retrieve, update business transactions which are occurred daily in business life. Data ware House: A data warehouse is used to record historical data, purely for analysis purpose for top management.
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Read Best Answer
Ans