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
where to store informatica rejected data?
difference between repository database and repository service?
How can you increase the performance in joiner transformation?
What are the transformations that are not supported in mapplet?
What do you mean by worklet?
What is the need for an etl tool?
What do mean by local and global repository?
Explain in detail about scd type 1 through mapping.
What is sequence generator transformation in informatica?
What is domain in terms of informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the uses of etl tools?
Design time, run time. If you don't create parameter what will happen
What is a sequence generator transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?