Coalesce field not indexed

[Chinthuja2]

Hi,

I am getting a pop up while I add coalesce to a field in transform map saying "Coalesce field not indexed".   I understand that it creates perfomrance issues, but I would like to know if this has any impact on the target field?

[Paul Curwen]

Hi Johnny,

It best practice to index any field you are using to coalesce on. It will improve the performance of your transform process no end.

Nice post on it here: Improve Import Set performance with the coalesce index feature in Fuji

Regards,

Paul.

[Chinthuja2]

Hello Curwen,

Thanks for the reply! I have gone through most of the posts which in the community which include the coalesce index issue. i undertsand that this is the best practice we should follow. For some reason, we are not allowed to create a new index field. This is the reason I posted this to know if there is any impact on target table if we continue to use the coalesce field which is not indexed.

[Chuck Tomasi]

If you continue to use the coalesce field without an index, your imports will be impacted, but not the target table.

[Chinthuja2]

thank you Mr.Tomasi.. That is what I wanted to confirm!