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 difference between mapping parameter and mapping variable?
what is diff b/t sorter t/r and agg have the option sorter property...
can you please explain me pre session and post session options?
Performance tuning( what you did in performance tuning)
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to create a non-reusable instance of reusable transformations?
What is the status code in stored procedure transformation?
What is target designer and target load order?
Explain Dataware house architecture .how data flow from intial to end?
Define sessions in informatica etl?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How can we remove the duplicates from flat file source?
What is exclusive and normal mode for repository services?
What is the cumulative sum and moving sum?