All Forums Database
hagedorn 11 posts Joined 04/10
26 Mar 2013
INFORMATICA USES SECONDARY INDEXES?

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

KS42982 137 posts Joined 12/12
26 Mar 2013

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.

KS42982 137 posts Joined 12/12
26 Mar 2013

I meant, "not with unique* SI"

hagedorn 11 posts Joined 04/10
29 Mar 2013

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

KS42982 137 posts Joined 12/12
01 Apr 2013

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

hagedorn 11 posts Joined 04/10
08 Apr 2013

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

You must sign in to leave a comment.