What is candidate check? - Data warehousing

What is candidate check?

Binning process when creates the binned indexes, answers only some queries. The base data is not checked. The process of checking the base data is called as a candidate check. Candidate check at times may consume more time that binning process. This depends on the user query and how well it matches with the bin.

What is candidate check?

Candidate check is a process that triggered during checking the base data. The performance of candidate check varies either towards the positive side or to the negative side. The overall performance of the candidate check is dependent on the query submitted by the user and also on the examining the base data.
What is Hybrid OLAP? - Data warehousing
Hybrid OLAP is a mode of storage that uses a combination of multidimensional data structures and relational database tables for storing multidimensional data.......
Explain the shared features of OLAP - Data warehousing
OLAP product by default is read only. If multiple access rights are required, admin needs to make necessary changes......
Compare Data Warehouse database and OLTP database - Data warehousing
Data Warehouse is used for business measures cannot be used to cater real time business needs of the organization and is optimized for lot of data......
Post your comment