Which kind of index is preferred in DWH?
Answer / warrenrame
Bitmap index is the best one. why because B-tree is suited
for unique values(eg: empid) and Bitmap is best for repeated
values(eg: gender m/f)
Is This Answer Correct ? | 6 Yes | 1 No |
Explain the versions of reportnet?
What is a data warehousing?
Explain what is the extension of file to save template?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
What is hybrid slowly changing dimension?
Explain what is the difference between powerplay transformer and power play reports?
What is the difference between ods and oltp?
What are modeling tools available in the market?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What are the steps involved in creating dimensional modeling process?