What r the type of indexes u generally used in informatica?
Answer Posted / 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 |
Post New Answer View All Answers
What is option by which we can run all the sessions in a batch simultaneously?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How do you change a non-reusable transformation to reusable transformation?
What is the sequence generator transformation in informatica?
Is there any way to read the ms excel datas directly into informatica?
What is meant by pre and post session shell command?
What are the performance considerations when working with aggregator transformation?
How to create Target definition for flat files?
When do you use sql override in a lookup transformation?
Define update strategy?
How does the aggregator transformation handle null values?
Enlist few areas or real-time situations where informatica is required.
What is a sequence generator transformation?
How to load last n records of file into target table - informatica
Where do we use mapping variables in informatica?