Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bitmap and Btree index?
- 3 Answers
- 19997 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishore
b-tree indexes are used usuall when we have too many
distinct columns and for high cardinaties . and bitmap
indexex are used for low cardinaties usually when we have
repeated columns.
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / 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 |
Answer / sarvesh
bit map incdex is an index in which the data will be in the
form of bites,by this we can retrieve the data very fastly
btree index is an index which is default index as
normal indexes.
| Is This Answer Correct ? | 14 Yes | 13 No |
what is incremental data aggregation?
What is DR strategy for Informatica project?
Explain constraint based loading in informatica
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
How to handle changing source file counts in a mapping?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
what is index?how it can work in informatica
wht is cdc?how to use it in creation of mappings?
What is the function of union transformation?
explain abt union t/r?
What is a data modeling?
How can you recover the session in sequential batches?
Teradata 
