What is the difference between Bitmap and Btree index?
- 3 Answers
- 19165 Views
- Mind Tree, I also Faced
- E-Mail Answers
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 do you take back up of repository?
Tell me about Propagate functions in informatica
What are the limitations of joiner transformation?
What are mapplets? How is it different from a Reusable Transformation?
What is the use of transformation?
Define mapping and session?
Performance tuning( what you did in performance tuning)
What is lookup change?
Where can we find the throughput option in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the fact table?
How do you load unique records into one target table and duplicate records into a different target table?
How might you approve all mappings in the archive all the while?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to load data in informatica ?
