Coalesce setting

[harshi_ramesh]

Hi all

I have set the coalesce in 'ID' field and mapped the same in the transform map. So if I set want to set 'Name' field as well in coalesce, will this create a problem in adding of new records?

For example, if there are records with same name, but different ID itself. Will the record be visible as only one record or each record will appear separately under same name?

Please help me with the solution.

Thanks

HR

[Sid_Takali]

Hi @harshi_ramesh Yes, exactly.

If 02ac record matches with target table to staging table, the record will get updated.

Please make my answer Correct/Helpful,

Regards,

Sid

[Sid_Takali]

@harshi_ramesh  In your case it will create a New Record with same Name and different ID.