What is the difference between bitmap and btree index?

Question Posted / guest

2 Answers
9989 Views
CTS, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between bitmap and btree index?..

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

What is the difference between bitmap and btree index?..

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

Post New Answer

More Informatica Interview Questions

What is the Rankindex in Ranktransformation?

7 Answers

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers TCS,

How to load last n records of file into target table - informatica

0 Answers Informatica,

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers Patni, Tech Mahindra,

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers

How to read data from flat file source if the data is in paragraph format?

2 Answers Wipro,

Describe two levels in which update strategy transformation sets?

1 Answers

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers Wipro,

Tell me about Propagate functions in informatica

0 Answers

why we need informatica

2 Answers HCL,

how will compare two mappings in two different repository?

2 Answers Real Time, TCS,

For more Informatica Interview Questions Click Here