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
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is meant by active and passive transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is informatica powercenter repository?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to generate sequence numbers using expression transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to generate sequence numbers?
Is stop and abort are same in informatica?
In informatica workflow manager, how many repositories can be created?
Global and Local shortcuts. Advantages.
How can we use batches?
What are the prerequisite tasks to achieve the session partition?
What is an active transformation?