What is the difference between bitmap and btree index?

Question Posted / guest

2 Answers
9958 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

What are the out put files that the informatica server creates during the session running?

2 Answers

what is bridge tables in informatica

1 Answers CTS,

What is the use of incremental aggregation?

2 Answers

What is critical mapping?

2 Answers

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers Cognizant,

Describe an informatica powercenter?

0 Answers

Explain pmcmd command usage in informatica

0 Answers Informatica,

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers HP,

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers

how to get the first row without using rank t/r?

7 Answers iGate,

For more Informatica Interview Questions Click Here