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


Please Help Members By Posting Answers For Below Questions

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3503


What is the function of aggregator transformation?

573


What is meant by a domain?

623


What is informatica etl tool?

548


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

783






What is the need for an etl tool?

631


How do you use reject loader.

2067


Explain the different dimensions.

548


What does command task mean?

606


What are the different types of transformation available in informatica.

632


Explain about Informatica server process that how it works relates to mapping variables?

618


Which version configuration tool used in ur project?

2762


Describe an informatica powercenter?

604


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1328


What do you mean by channel change?

537