Home | Interview Questions | Data Warehousing | Data Warehousing Basics

Data Warehousing Basics

What is DTM session?

What is DTM session?
Full details

What is Conceptual, Logical and Physical model

What is Conceptual, Logical and Physical model? ...
Full details

What is up date strategy?

What is up date strategy?...
Full details

What is Cognos script editor?

What is Cognos script editor? ...
Full details

What are Data Marts?

What are Data Marts? ...
Full details

What is data cleansing?

What is data cleansing? ...
Full details

What is aggregate awareness?

What is aggregate awareness? ...
Full details

Explain clustering algorithm?

Explain clustering algorithm? ...
Full details

What is hash partition?

What is hash partition? ...
Full details

What is staging area?

What is staging area?...
Full details

What is an OLAP

What is an OLAP ...
Full details

What is query panel?

What is query panel? ...
Full details

What is Bulk Insert?

What is Bulk Insert? ...
Full details

What is MDX?

What is MDX? ...
Full details

What are the types of dimension tables?

What are the types of dimension tables? ...
Full details

How can you define a transformation?

How can you define a transformation? ...
Full details

What is BCP?

What is BCP? ...
Full details

What is Time Series algorithm

What is Time Series algorithm in data mining? ...
Full details

What is ETL?

What is ETL? ...
Full details

What is the difference between ETL tool

What is the difference between ETL tool and OLAP tools? ...
Full details

What are CUBES?

What are CUBES? ...
Full details

What are different types of transformations

What are different types of transformations in Informatica? ...
Full details

What is Snow Flake Schema design

What is Snow Flake Schema design in database? ...
Full details

What is operational data source (ODS)?

What is operational data source (ODS)? ...
Full details

What is a look up function?

What is a look up function? ...
Full details

What is difference between DSS & OLTP?

What is difference between DSS & OLTP? ...
Full details

What are parallel queries

What are parallel queries and query hints? ...
Full details

What is IQD file?

What is IQD file? ...
Full details

What is Sequence clustering algorithm

What is Sequence clustering algorithm? ...
Full details

What is the difference between OLAP, ROLAP, MOLAP

What is the difference between OLAP, ROLAP, MOLAP ...
Full details

What is XMLA?

What is XMLA? ...
Full details

What is a star schema?

What is a star schema? ...
Full details

What is a Data Cube?

What is a Data Cube? ...
Full details

How does Oracle support the ETL process?

How does Oracle support the ETL process? ...
Full details

What is Meta data and system catalog?

What is Meta data and system catalog? ...
Full details

What is confirmed dimension?

What is confirmed dimension? ...
Full details

What is mapplet?

What is mapplet? ...
Full details

What is Data mining?

What is Data mining? ...
Full details

What is Data purging?

What is Data purging? ...
Full details

What is Discrete and Continuous data

What is Discrete and Continuous data in Data mining world? ...
Full details

What is an OLTP

What is an OLTP ...
Full details

What is multi-dimensional analysis?

What is multi-dimensional analysis? ...
Full details

Explain Association algorithm in Data mining?

Explain Association algorithm in Data mining? ...
Full details

What is Discover and Execute in XMLA?

What is Discover and Execute in XMLA? ...
Full details

Which automation tool is used in data warehouse

Which automation tool is used in data warehouse testing? ...
Full details

What is the difference between a Warehouse

What is the difference between a Warehouse and an OLTP application? ...
Full details

What is the difference between Oracle Express

What is the difference between Oracle Express and Oracle Discoverer? ...
Full details

What is the difference between an ODS and a Warehouse?

What is the difference between an ODS and a Warehouse? ...
Full details

What are the primary ways to store data in OLAP?

What are the primary ways to store data in OLAP? ...
Full details

What are different stages of Data mining?

What are different stages of Data mining? ...
Full details

What is a Decision Tree Algorithm?

What is a Decision Tree Algorithm? ...
Full details

What are different deliverables according to phases?

What are different deliverables according to phases? ...
Full details

What is Analysis Services?

What is Analysis Services? ...
Full details

Why do we use DSS database for OLAP tools?

Why do we use DSS database for OLAP tools? ...
Full details

What is difference between Power Play transformer

What is difference between Power Play transformer and power play reports? ...
Full details

What is source qualifier?

What is source qualifier?...
Full details

What is difference between Mapplet

What is difference between Mapplet and reusable transformation? ...
Full details

What are advantages of de normalized data?

What are advantages of de normalized data? ...
Full details

Which kind of index is preferred in DWH?

Which kind of index is preferred in DWH? ...
Full details

What is ETL process in Data warehousing?

What is ETL process in Data warehousing? ...
Full details

What is Data Warehousing?

What is Data Warehousing? ...
Full details

What are Fact tables and Dimension Tables?

What are Fact tables and Dimension Tables? ...
Full details

What is difference between a connected look up

What is difference between a connected look up and unconnected look up? ...
Full details

What is data merging

What is data merging?...
Full details

What is power play plug in?

What is power play plug in? ...
Full details
Log in
Popular tags