What is the difference between bitmap and btree index?
- 2 Answers
- 8952 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answer Posted / amarnath
Bitmap index is used on low cardinality columns i.e less
distinct columns eg: Gender: Male/Female.
B-tree is used on high cardinality colums
eg: Student first name
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How are indexes created after completing the load process?
Mention few advantages of router transformation over filter transformation.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the new features of informatica 9.x in developer level?
expain about the tune parameters?
What is sq transformation?
COM components can be used in Informatica
what is SDLC way of code development?
Informatica Checkpoints
What is a joiner transformation and why it is an active one?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the issues you have faced in your project? How did you overcome those issues?
Describe data concatenation?
What is the function of union transformation?
Which version configuration tool used in ur project?
