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 look up transformation?

1175

Briefly describe lookup transformation?

1095

What do think which one is the better joiner or look up?

1246

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108

What is a filter transformation and why it is an active one?

1015

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2577

Can anyone tell me the new features in Informatica 9 Version?

2207

What is option by which we can run all the sessions in a batch simultaneously?

1192

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2127

What are the designer tools for creating transformations?

1158

what are the deliverables?in your project?

2194

How to go to the older version for a mapping?

1157

Can u generate reports in Informatica?

1143

can you please explain me pre session and post session options?

7673