Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6174


What is joiner change?

1144


What is workflow? What are the components of the workflow manager?

1128


How can you define user defied event?

1026


whats the logic to load the lower level of granularity of data to fact table.

2269


Scheduling properties,whats the default (sequential)

1950


Suppose we do not group by on any ports of the aggregator what will be the output?

1041


What are the conditions needed to improve the performance of informatica aggregator transformation?

1086


What are the data movement modes in informatica?

1145


What is difference between a gateway node and worker node?

1133


What is incremental aggregation?

1077


Explain the informatica workflow?

1050


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2352


What is the procedure for creating independent data marts from informatica 7.1?

1060


wat are deployement groups in informatica, how it will be used for developers

1714