What is the difference between bitmap and btree index?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amarnath
Bitmap index is used on low cardinality columns i.e less
distinct columns eg: Gender: Male/Female.
B-tree is used on high cardinality colums
eg: Student first name
| Is This Answer Correct ? | 8 Yes | 1 No |
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
How many repositories can be created in informatica?
What is a grid in Informatica?
need for registering a repository server
What is the different lookup cache(s)?
What is standalone command task?
what is the flow?
When the informatica server marks that a batch is failed?
Can we create multiple integration service on single repository?
What is joiner change?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
How do you set a varible in incremental aggregation