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 the function of aggregator transformation?

1076

How many transformations can be used in mapplets.

1927

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2112

Why do you use Mapping Parameter and mapping variable?

1755

What is a passive transformation?

1092

Why update strategy and union transformations are active? Explain with examples.

1228

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

How to improve the performance of a session using sorter transformation?

1142

How to elaborate powercenter integration service?

1127

What are the restrictions of union transformation?

1032

explan ur project architecture?

2053

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2129

Explain joiner transformation in informatica

1120

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1027

What is persistent lookup cache?

1024