What r the type of indexes u generally used in informatica?

Answer Posted / sanjay gupta

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a repository manager?

841


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1404


How we can use union transformation?

789


What are the conditions needed to improve the performance of informatica aggregator transformation?

804


Why union transformation is an active transformation?

848


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

814


What is powercenter on grid?

920


What are multi-group transformations?

771


What is joiner change?

897


What is meant by lookup transformation?

785


Explian the Process of deployment groups in informatica

812


How many number of sessions can one group in batches?

889


in reporting we add some new objects,how we get the count of the newly added objects to the report

1964


Which is the t/r that builts only single cache memory?

927


generate date / time dimension in informatica

876