KyaPoocha.com

Related Interview Questions

• What is the difference between OLAP and OLTP?  28.11.08

  OLAP stands for online analytical processing . In this we have access to live data. This process contain historical information to analyze. Data needs to be int...

• What is the definition of normalized and denormalized view and what are the differences between them ?  23.09.08

  I would like to add one more pt. here, as OLTP is in Normalized form, more no. of tables are scanned or referred for a single query, as through primary key and...

• 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...

• Explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions ?  20.09.08

  OLTP(1)---->ODS(2)------>DWH(3)-------->OLAP(4)------------>Reports(5)------>decision(6) 1-2 (extraction) 2-3 (Transformation and here ODS is itself staging...

• What is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP? (NOT AS A RELATIONAL,MULTI, HYBRID?)  20.09.08

  Rolap : Relational Olap,these functionality are used in Business Objects. Molap : Multi Dimensional Olap Functionality are used in Cognos. Hloap : Hybrid Ola...

• Explain ODS and ODS types ?  20.09.08

  OLTP Systems : Type I + ER Modelling ODS : Type II + ER Modelling DWH : Type II + Dimensional modelling People use ODS as a alternative to DWH ofcourse...

• What is the difference between OLAP and Data Mining?  30.07.06

  OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-cli...

• Why should you put your data warehouse on a different system than your OLTP system?  17.03.06

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

• What is the Difference between OLTP and OLAP?  17.03.06

  Main Differences between OLTP and OLAP are:- 1. User and System Orientation OLTP: customer-oriented, used for data analysis and querying by clerks, client...

• Why are OLTP database designs not generally a good idea for a Data Warehouse?  17.03.06

  Since in OLTP,tables are normalised and hence query response will be slow for end user and OLTP doesnot contain years of data and hence cannot be analysed....