Bitmap index is used for repeating values. ex: Gender:male/female A

What is the difference between bitmap and btree index?

Question Posted / sneha latha.r

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

Please Help Members By Posting Answers For Below Questions

What is an aggregator transformation?

1096

What are the different options available for update strategy?

1000

What are roles and groups and benefits of using them?

1055

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

1041

What are the issues you have faced in your project? How did you overcome those issues?

2359

if we have a delimiters at unwanted places in a flat file how can we over come those.

2045

What is Session and Batches?

1104

Describe expression transformation?

1114

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

1117

How to create the source and target database connections in server manager?

1084

how to create user defined function (udf) in informatica

1299

What differs when we choose the sorted input for aggregator transformation?

1014

What are the different lookup cache(s)?

1113

Write the unconnected lookup syntax and how to return more than one column.

1106

What are the features of complex mapping?

1151