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?

Answers were Sorted based on User's Feedback



What is the difference between Bitmap and Btree index?..

Answer / 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

What is the difference between Bitmap and Btree index?..

Answer / ranvir thakor

WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.

Is This Answer Correct ?    8 Yes 1 No

What is the difference between Bitmap and Btree index?..

Answer / sarvesh

bit map incdex is an index in which the data will be in the
form of bites,by this we can retrieve the data very fastly
btree index is an index which is default index as
normal indexes.

Is This Answer Correct ?    14 Yes 13 No

Post New Answer

More Informatica Interview Questions

What is meant by active and passive transformation?

0 Answers  


What is the function of look up transformation?

0 Answers  


Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,


what is the difference between onsite & client site?

1 Answers  


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  


Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,


without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,


What are the different clients of powercenter?

0 Answers  


Explain about cumulative Sum or moving sum?

0 Answers   Informatica,


what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  


When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,


Can we make worklet inside worklet?

1 Answers  


Categories