-> Data Warehouse Basics Interview Questions

Data Warehouse Basics

What is Data purging?
What is data merging?
What is Analysis Services?
What is staging area?
What is the difference between OLAP, ROLAP, MOLAP and HOLAP
What is DTS?
What is XMLA?
What are cursors?
What is Time Series algorithm in data mining?
What is operational data source (ODS)?
What is up date strategy?
What is a Data Cube?
What is Meta data and system catalog?
How does Oracle support the ETL process?
What is Snow Flake Schema design in database?
What is DTM session?
What are parallel queries and query hints?
What are CUBES?
What are Fact tables and Dimension Tables?
Which automation tool is used in data warehouse testing?
Explain clustering algorithm?
How can you define a transformation?
What is ETL?
What is Discover and Execute in XMLA?
What are different types of transformations in Informatica?
What is the difference between an ODS and a Warehouse?
Explain in simple terms, the concept of Data Mining.
What is Conceptual, Logical and Physical model?
What is IQD file?
What is sampling?
What Oracle tools can be used to design and build a Warehouse?
What are advantages of de normalized data?
What is Cognos script editor?
What is Bulk Insert?
What are the types of dimension tables?
What is confirmed dimension?
What is data cleansing?
What is an OLAP (On-line Analytical processing) system?
What is a star schema?
What is a Decision Tree Algorithm?
What is mapplet?
What is fact less fact schema?
What are the different problems that “Data mining” can solve?
What is a Data Warehouse?
What are different deliverables according to phases?
What is query panel?
What is aggregate awareness?
What is hash partition?
How did you plan your Data ware house project?
What is ETL process in Data warehousing?
What Oracle features can be used to optimize my Warehouse system?
What is a data validation strategy for data mart validation
How are models actually derived?
What is difference between Mapplet and reusable transformation?
Which kind of index is preferred in DWH?
Explain Association algorithm in Data mining?
What is difference between Mapplet and reusable transformation?
What is difference between Mapplet and reusable
What is staging area?
What are CUBES?
Explain Association algorithm in Data mining?
What are the types of dimension tables?
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
How many repositories can we create in Informatica?
What is Data Warehousing?
What is Data Warehousing?
What is MDX?
How does data mining and data warehousing work together?
Where can one get more info about Data Warehousing?
What are different stages of “Data mining”?
What is the capacity of power cube?
Data warehousing / Data Mining, Data Warehouse Basics, What is difference between DSS & OLTP?
What is difference between DSS & OLTP?
What is a look up function?
What are the primary ways to store data in OLAP?
What are algorithms provided by Microsoft in SQL Server?
What is the difference between a Warehouse and an OLTP application?
What is BCP?
What is the difference between Oracle Express and Oracle Discoverer?
What is the difference between a data warehouse and a data mart?
What is META DATA information in Data warehousing projects?
What is source qualifier?
What is difference between Power Play transformer
Why do we use DSS database for OLAP tools?
What is an OLTP (Online Transaction Processing) System?
What is Sequence clustering algorithm?
When should you use a STAR and when a SNOW-FLAKE schema?
What is the difference between ETL tool and OLAP tools?
What is multi-dimensional analysis?
What is “Data mining”?
What is difference between a connected look up and unconnected look up?
What is power play plug in?