Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bitmap and Btree index?
- 3 Answers
- 19872 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 |
I have source like this 1:2;3. so i want to load the target as 123
how can u approach u r client
What is metadata reporter?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Explain constraint based loading in informatica
What is dimensional table? Explain the different dimensions.
What the difference is between a database, a data warehouse and a data mart?
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
write a query to retrieve the latest records from the table sorted by version(scd)
What is the function of look up transformation?
Teradata 
