What is the difference between bitmap and btree index?
- 2 Answers
- 8945 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 |
Why use the lookup transformation ?
Which will beter perform IIf or decode?
4 yrs etl devloper roles and responsibilities?any body give solutions
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
Why you use repository connectivity?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
What is operational data source (ODS)?
What are active and passive transformations?
Write the unconnected lookup syntax and how to return more than one column.
Is informatica power center designer has 64 bit support?
Mapplets can you use an active transformation in a mapplet,
Teradata 
