What r the type of indexes u generally used in informatica?
Answers were Sorted based on User's Feedback
Normally we use two types of indexes in informatica.
Btree Index
Bitmap Index
Bitmap Index gives better performance than Btree Index.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / javidakram
b tree and bitmap indexes we r using in informatica. b tree
is low cardinality and bitmap have high cardinality that is
why bitmap index gives better performance.
| Is This Answer Correct ? | 6 Yes | 2 No |
hw cn v elimate dublicate values from lookup without overriding sql?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
Why we select the table which has minimum number of records as Master table in joiner?
is it possible to index the data in cache of lkp transformation ?
Where is the cache stored in informatica?
Explian the Process of deployment groups in informatica
who to split dimentions into sub dimention
Is it possible to create multiple domains on a single Informatica server?
What is option by which we can run all the sessions in a batch simultaneously?
What are the informatica performance improvement tips
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the mapping paramaters and mapping variables?