Data Warehousing interview questions part 2
Data Scheme is a diagrammatic representation that illustrates
data structures and data relationships to each other in the relational database
within the data warehouse................
Read answer
Bitmap indexes make use of bit arrays (bitmaps) to answer
queries by performing bitwise logical operations..................
Read
answer
In hierarchical, networked or relational databases, the data
can be extracted, cleansed and transferred in two directions. The ability of a
system to do this is refered to as bidirectional extracts................
Read
answer
Data collection frequency is the rate at which data is
collected. However, the data is not just collected and stored. it goes through
various stages of processing like extracting from various sources, cleansing,
transforming and then storing in useful patterns................
Read answer
|
