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 what are the different types of transformation available in informatica.
Explain the scenario which compels informatica server to reject files?
Explain target update override in informatica
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the etl program with few examples.
what are factless facts? And in which scenario will you use such kinds of fact tables.
which one is better performance wise joiner or look up
What are the tasks that source qualifier perform?
What is the use of target designer?
Can we change Dynamic to Static or Persistent cache? If so what happens?
what are the Methods For Creating Reusable Transformations?
Explain the code page compatibility?
what is the size of your data warehousing?
Explain the shared cache and re-cache?
What are the different transaction levels available in transaction control transformation?