What is the difference between bitmap and btree index?
Answer Posted / 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 |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How you can differentiate between connected lookup and unconnected lookup?
What is a joiner transformation and why it is an active one?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is expression transformation?
How to go to the older version for a mapping?
What is intricate mapping?
What is dynamic cache?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is an unconnected transformation?
What is standalone command task?
What are the informatica performance improvement tips
What happens when a session fails and you click on recover?
Enlist the tasks for which source qualifier transformation is used.