What is the difference between Bitmap and Btree index?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the shared cache and re-cache?
Explain the scenario which compels informatica server to reject files?
What are the types of caches in lookup? Explain them.
Explain pushdown optimization and types in informatica
What is the surrogate key?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Clarify the aggregator change?
What is the need of an ETL tool?
What is the difference between informatics 7x and 8x and what is latest version?
What do you understand by term role-playing dimension?
What is aggregator transformation in informatica?
Where is metadata stored?
How to load the data from a flat file into the target where the source flat file name changes daily?
What differs when we choose the sorted input for aggregator transformation?
Name the different lookup cache(s)?