Technology Questions

Following are the data integration factors:

- Sub set of the available data should be optimal. 

- Noise/distortion estimation levels because of sensory/processing conditions at the time of data collection.

- Accuracy, spatial and spectral resolution of data.

- Data formats, storage and retrieval mechanisms.

- Efficiency of computation for integrating data sets to reach the goals.

To make this method available to every implementation class

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.

Overloading allows multiple functions to exist with same name but different parameters. Again if you take bike as an example, it has a function “Start” with two forms i.e. ’Auto Start’ and ’kick start’.

Trigger allows us to execute a batch of SQL code when an insert, update or delete command is executed against a specific table.

Triggers are special types of stored procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the insert, delete and update operation.

•  NO_CACHE – It is used for not caching values.


•  PRE_LOAD_CACHE – Result column preloads and compares the column into the memory, prior to executing the lookup.


•  PRE_LOAD_CACHE is used when the table can exactly fit in the memory space.


•  DEMAND_LOAD_CACHE – Result column loads and compares the column into the memory when a function performs the execution.


•  DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data.

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.