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 are the restrictions of union transformation?
What is a code page?
Explain what are the different versions of informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is target designer and target load order?
what are factless facts? And in which scenario will you use such kinds of fact tables.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What happens when a session fails and you click on recover?
What are the measure objects?
What is the command used to run a batch?
What is domain in terms of informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is INFORMATICA TESTING process
what is mean by complex business rule ?