What is the difference between bitmap and btree index?
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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is joiner change?
What is workflow? What are the components of the workflow manager?
How can you define user defied event?
whats the logic to load the lower level of granularity of data to fact table.
Scheduling properties,whats the default (sequential)
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the data movement modes in informatica?
What is difference between a gateway node and worker node?
What is incremental aggregation?
Explain the informatica workflow?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the procedure for creating independent data marts from informatica 7.1?
wat are deployement groups in informatica, how it will be used for developers