Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between bitmap and btree index?
- 2 Answers
- 10109 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 |
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
How do you use reject loader.
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Explain the flow of data in Iinformatica?
What is aggregate cache in aggregator transforamtion?
Router T/R is active but some people are saying it is also passive which is exactly right?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Diffrence between static and dynamic cache
How many number of sessions that u can create in a batch?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
How to call shell scripts from informatica?
Teradata 
