KyaPoocha.com

Related Interview Questions

• Briefly state different between data ware house & data mart?  28.11.08

  1) Dataware house is made up of many datamarts. DWH contain many subject areas. but data mart focuses on one subject area generally. e.g. If there will be DHW o...

• What are Data Marts ?  25.09.08

  Data Mart: a data mart is a small data warehouse. In general, a data warehouse is divided into small units according the busness requirements. for example, if w...

• What is the main difference between Inmon and Kimball philosophies of data warehousing?  23.09.08

  Both differed in the concept of building teh datawarehosue.. According to Kimball ... Kimball views data warehousing as a constituency of data marts. Data...

• What is the main difference between Inmon and Kimball philosophies of data warehousing?  22.09.08

  Both differed in the concept of building teh datawarehosue.. According to Kimball ... Kimball views data warehousing as a constituency of data marts. Data...

• What are the different architecture of datawarehouse ?  22.09.08

  There are three types of architectures. Datewarehouse Basic Architecture : In this architecture end users access data that is derived from several sources...

• How data in datawarehouse stored after data has been extracted and transformed from hetrogeneous sources and where does the data go from datawarehouse ?  22.09.08

  Data will stored in fact's and dimensional tables, the relational database can be Oracle, Informatic or netezza, it purely depends upon the company which techno...

• Summarize the differene between OLTP,ODS AND DATA WAREHOUSE ?  22.09.08

  oltp - means online transaction processiing ,it is nothing but a database ,we are calling oracle,sqlserver,db2 are olap tools. OLTP databases, as the name im...

• What are Data Marts?  18.09.08

  A data mart is a focused subset of a data warehouse that deals with a single area(like different department) of data and is organized for quick analysis....

• Explain the difference between microkernel and macro kernel?  20.08.08

  A monolithic kernel has all OS services running within the privileged mode of processor.It has only one address space i.e. kernel space. A micro-kernel uses...

• What are Data Marts?  17.03.06

  Data Marts are designed to help manager make strategic decisions about their business. Data Marts are subset of the corporate-wide data that is of value to a s...