What is the difference between Bitmap and Btree index?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank transform?

611


What does “tail –f” command do and what is its use as an Informatica admin.

637


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1476


Differentiate between a repository server and a powerhouse?

590


what is INFORMATICA TESTING process

1851






Different sorts of metadata that stores in the storage facility?

574


Different qualification between a related rotate toward the sky and isolates look upward?

565


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

630


Design a mapping to load a target table with the following values from the above source?

891


How to generate or load values in to the target table based on a column value using informatica etl tool.

619


What is lookup change?

626


What is meant by a domain?

641


Explain pushdown optimization and types in informatica

676


What is informatica metadata and where is it stored?

600


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1599