What is the difference between Bitmap and Btree index?

Question Posted / laxman

3 Answers
20019 Views
Mind Tree, I also Faced
E-Mail Answers

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 decode in informatica?

0 Answers

What is A cache?

2 Answers

Is it possible to create multiple domains on a single Informatica server?

0 Answers

How to load a Dimension ? and how to load a fact table?

0 Answers

What is source qualifier?

6 Answers SDS,

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers Informatica,

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers

Enterprise data warehouse your projects phase by phase explain?

0 Answers Cap Gemini,

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers

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

2 Answers

For more Informatica Interview Questions Click Here