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

Is stop and abort are same in informatica?

1006

What does refresh system mean, and what are its distinctive choice?

1188

What is a difference between complete, stop and abort?

1091

What is a mapplet/worklet in informatica?

1192

waht type of interface is used for testing the data in informatica

2260

What are the new features of informatica 9.x developer?

972

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1177

What is exclusive and normal mode for repository services?

1150

Differentiate between joiner and lookup transformation?

1106

What is the need of an ETL tool?

1108

Explain about Informatica server process that how it works relates to mapping variables?

1089

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1288

Have you worked with/created Parameter file

1668

What do you understand by term role-playing dimension?

1052

What are the limitations of joiner transformation?

1114