Warning: Coalesce field not indexed

[Nikhil Dixit]

Hi Experts,

I am seeing one warning alert while transforming data from import set table to target table only when I inserted coalesce for one of the fields on table. It is working as expected when removed coalesce.

Alert Message: "None of fields configured to coalesce are indexed on the target table. Unindexed coalesce fields may impact performance during transformation. If you want to create an index, click OK. Otherwise, click Cancel to return to your transform map."

I am getting one alert window as following after close the warning alert.

Please look into attached screenshot as a reference for warning alert.

Please help me to get reason that why do this alert popup and how to avoid it ?

-- 

Warm Regards

Nikhil Dixit

Engineer

| www.DxSherpa.com | Skype : nnikkhil2709dixit |

[nayanawadhiya1 · Accepted solution]

Hello,

Below link will help to understand the propose of indexing of coalesce field.

Improve Import Set performance with the coalesce index feature in Fuji

[shahenas1]

Hello,

The link which you provided is throwing an error.

An Unexpected Error has occurred.

could you please share the correct link.

[nayanawadhiya1]

Any update on this?
Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

[shahenas1]

Hello,
Did you figure this out ??

Actually I am also facing the same issue.

Could you please share the solution or link to refer please.

Thanks,
Shahena.