What is the difference between bitmap and btree index?
Answer Posted / 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 View All Answers
Write the unconnected lookup syntax and how to return more than one column.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain joiner transformation in informatica
Explain how to import oracle sequence into informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is a sequence generator transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What the difference is between a database, a data warehouse and a data mart?
Enlist the various types of transformations.
What is the fact table?
Informatica Checkpoints
How can one identify whether mapping is correct or not without connecting session?
expain about the tune parameters?