What is the difference between bitmap and btree index?
- 2 Answers
- 8951 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
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is a predefined event?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the limitations of joiner transformation?
How you can differentiate between connected lookup and unconnected lookup?
What are mapplets?
What are the new features of Power Center 5.0?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the different lookup cache(s)?
What is the advantage of informatica?
is it possible to index the data in cache of lkp transformation ?
Explain the aggregator transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
