Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between bitmap and btree index?
- 2 Answers
- 10094 Views
- CTS, TCS, I also Faced
- E-Mail Answers
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 |
list out all the transformations which use cache?
I have source like this 1:2;3. so i want to load the target as 123
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
What is the difference between a router and a filter transformation?
Why update strategy and union transformations are active? Explain with examples.
Can we insert and update a target table without using update strategy transformation?How?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
How do you load only null records into target?
What will be the approach?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
How do you remove duplicate records in informatica?
Teradata 
