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
How can we delete duplicate rows from flat files?
Describe data concatenation?
What is expression transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What do think which one is the better joiner or look up?
Enlist some properties of sessions.
Tell me about Propagate functions in informatica
What do you mean by enterprise data warehousing?
Is it possible to define a single node as a Gateway node as well as worker node?
Is stop and abort are same in informatica?
Explain Dataware house architecture .how data flow from intial to end?
What are the reusable transformations?
What is decode in static cache?
What are the features of complex mapping?
what are the deliverables?in your project?