Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bitmap and Btree index?
- 3 Answers
- 20162 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishore
b-tree indexes are used usuall when we have too many
distinct columns and for high cardinaties . and bitmap
indexex are used for low cardinaties usually when we have
repeated columns.
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / ranvir thakor
WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / sarvesh
bit map incdex is an index in which the data will be in the
form of bites,by this we can retrieve the data very fastly
btree index is an index which is default index as
normal indexes.
| Is This Answer Correct ? | 14 Yes | 13 No |
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
Define filter transformation?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
A session S_MAP1 is in Repository A. While running the session error message has displayed
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
how to declare array in plsql?
How is union transformation utilized?
In real time scenario where can we use mapping parameters and variables?
Explain Dataware house architecture .how data flow from intial to end?
What is powercenter on grid?
Teradata 
