What is the difference between Bitmap and Btree index?
Answer Posted / kishore
b-tree indexes are used usuall when we have too many
distinct columns and for high cardinaties . and bitmap
indexex are used for low cardinaties usually when we have
repeated columns.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What is data transformation manager process?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Difference between Target-based loading and constraint-based loading?
Which development components of informatica have the highest usage?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Differentiate between reusable transformation and mapplet.
What is the difference between a repository server and a powerhouse?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
update strategy transformation in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the static cache and dynamic cache in informatica?
What do you mean by enterprise data warehousing?
Different circumstance which drives informatica server to expel records?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.