Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bitmap and Btree index?
- 3 Answers
- 19827 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 |
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
we have to use order by,where,having we to implement sql query
What is the need of building a data warehouse?
What is mapplet in informatica?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
What differs when we choose the sorted input for aggregator transformation?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What are the active and passive transforamtions?
why sequence generator should not directly connected to joiner transformation ?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
What are pre and post-session shell commands?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
Teradata 
