What is the difference between bitmap and btree index?

Question Posted / guest

2 Answers
10111 Views
CTS, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between bitmap and btree index?..

Answer / sneha latha.r

Bitmap index is used for repeating values.

ex: Gender:male/female
Account status:Active/Inactive

Btree index is used for unique values.

ex: empid.

Is This Answer Correct ?

12 Yes

1 No

What is the difference between bitmap and btree index?..

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

More Informatica Interview Questions

where actually the usage of push down optimization happens...

2 Answers

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers iGate,

What is a code page in Informatica

3 Answers American Express, Cognizant, Deloitte,

What is a snowflake schema?

0 Answers

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers TCS,

how we can load rejected record's at run time?(not through bad files)

0 Answers TCS,

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

0 Answers

What is informatica? What exactly are the practical uses in real world

2 Answers

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers PayPal,

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers

What are the components of workflow manager?

0 Answers

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers Puma,

For more Informatica Interview Questions Click Here