What is the difference between Bitmap and Btree index?
Answer Posted / ranvir thakor
WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
can u any challenge your project?
What are the informatica performance improvement tips
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is a repository? And how to add it in an informatica client?
Explain the informatica workflow?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain your project of banking domian.
Design time, run time. If you don't create parameter what will happen
What is joiner transformation?
What are different types of transformations available in informatica?
What is a rank transform?
What is a surrogate key?
What are junk dimensions?
Slowly changing dimensions, types and where will you use them
What is Data Caches size?