What is the difference between bitmap and btree index?
- 2 Answers
- 8938 Views
- CTS, TCS, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
What is session task and command task?
how we can load rejected record's at run time?(not through bad files)
Parameter and variable differences
Mention few advantages of router transformation over filter transformation.
How to load the data from a flat file into the target where the source flat file name changes daily?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Which transformation should we use to normalise the COBOL and relational sources?
What is olap (on-line analytical processing?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is different between the data warehouse and data mart?
What is a stored procedure transformation?
what is index?how it can work in informatica
Explain sessions and how many types of sessions are there?
What is expression transformation?
