INFORMATICA USES SECONDARY INDEXES?

Database
Enthusiast

INFORMATICA USES SECONDARY INDEXES?

A developer indicated to me that Informatica will not use secondary indexes. Is this true?
5 REPLIES
Enthusiast

Re: INFORMATICA USES SECONDARY INDEXES?

If you are doing Fload or Mload with informatica then it would not work with secondary indexes. However, in Mload it would work with Non-unique SI, but not with SI.

Enthusiast

Re: INFORMATICA USES SECONDARY INDEXES?

I meant, "not with unique* SI"

Enthusiast

Re: INFORMATICA USES SECONDARY INDEXES?

How about an UPDATE TPT process workflow? Will it utilize SI if they are created over the columns in the where clause?
Enthusiast

Re: INFORMATICA USES SECONDARY INDEXES?

No, I don't think UPDATE TPT also supports unique SI.

Enthusiast

Re: INFORMATICA USES SECONDARY INDEXES?

Thank you for the answer and from what I see, that is correct!