- How to use the tool Onto builders educational institution
- What is the use of surrogate key in business objects
- What is Molap and Rolap? What is Difference between Them
- What is degenerated dimension &it's uses
- What is the difference between ODS and Staging
- How can one connect two fact tables?is it possible how
- Suppose data are coming from different locations and those data will not change
- What is the difference between aggregate table and fact table ? how do you load these
- Where can one get more info about Data Warehousing
- What Oracle features can be used to optimize my Warehouse system
- How can Oracle Materialized Views be used to speed up data warehouse queries
- What is the difference between Oracle Express and Oracle Discoverer
- When should you use a STAR and when a SNOW-FLAKE schema
- What is a star schema? Why does one design this way
- When should one use an MD-database (multi-dimensional database) and not a relational
- What Oracle tools can be used to design and build a W/H
- What is the difference between an ODS and a W/H
- What is the difference between OLAP, ROLAP, MOLAP and HOLAP
- What is the difference between a W/H and an OLTP application
- What is the difference between a data warehouse and a data mart
- What is a ETL? How does Oracle support the ETL process
- What is a Data Warehouse
- What are the types of dimension tables
- What is the difference between ETL tool and OLAP tools
- What is data validation strategies for data mart validation after loading process
- Which automation tool is used in data warehouse testing
- How can one transfer LOB and user defined data from oracle to warehouse using ETL
- What is a Data Cube
- Give me a broad concept of what a data warehouse is, and what it might be used for
- What is Discover and Execute in XMLA
- What is XMLA
- How does data mining and data warehousing work together
- What are algorithms provided by Microsoft in SQL Server
- What is Sequence clustering algorithm
- Explain Association algorithm in Data mining
- What is Time Series algorithm in data mining
- Explain clustering algorithm
- Can decision tree be implemented using SQL
- What is a Decision Tree Algorithm
- How are models actually derived
- What is Discrete and Continuous data in Data mining world
- What are different stages of Data mining
- What are the different problems that Data mining can solve
- What is MODEL in Data mining world
- Can you explain how analysis service works
- What are different deliverables according to phases
- How did you plan your Data ware house project
- What is MDX
- What is multi-dimensional analysis
- What is META DATA information in Data warehousing projects
- What are the primary ways to store data in OLAP
- What are CUBES
- What is Analysis Services
- What is Data purging
- What is Conceptual, Logical and Physical model
- What is an OLTP (Online Transaction Processing) System
- Can you brief about the Data warehouse project you worked on
- What is DTS
- What is Bulk Insert
- How can we import and export using BCP utility
- What is BCP
- How can we do ETL process in SQL Server
- What is ETL process in Data warehousing
- What is Snow Flake Schema design in database
- What are Fact tables and Dimension Tables
- What are Data Marts
- Why do we use DSS database for OLAP tools
- What is subject area
- What is up date strategy and what are the options for update strategy
- What is data merging, data cleansing and sampling
- What is staging area
- What is difference between a connected look up and unconnected look up
- What is a look up function? What is default transformation for the look up function
- What is query panel
- What is mapplet
- How can you define a transformation? What are different types of transformations in
- What is DTM session
- What is hash partition
- Which kind of index is preferred in DWH
- What is power play plug in
- What is Cognos script editor
- What is IQD file
- What is the capacity of power cube
- What is confirmed dimension
- What is factless fact schema
- What is meta data and system catalog
- What is operational data source (ODS)
- Advantages of de normalized data
- What are cursors
- What are parallel queries and query hints
- Explain reference cursor
- What is aggregate awareness
- What is difference between Mapplet and reusable transformation
- How many repositories can we create in Informatica
- Explain grouped cross tab
- Difference between DSS & OLTP
- What is source qualifier