Multiple Coalesce field in Transform Map

[Kirtiman]

Hi,

I have two fields marked as Coalesce true in my transform map. For optimal performance of data load in target table shall I get index set up for both the fields, in target table?

Kind Regards

Kirtiman

[Sagar Pagar]

Hi,

As per my understanding, indexing on a table to allow users to search for string values from table records.

Benefits of Index-

- Indexes will improve the Query/SQL performance(i.e. GlideRecord Query Response Times) in Scripts.
- Indexes will improve searches on Lists/ Form load times.
- Global search
- Reports/ Homepages/ Dashboards

For data load there is no need to create an index on the target table.

Thanks,
Sagar Pagar

[Kirtiman]

Hi,

I don't think this is correct practice else SN won't have shown below warning message if you have a field set as "Coalesce" in Transform Map but don't have the same field indexed in target table. While I know we have to do it for a single coalesce field in Transform Map but not sure if we have more than one field set as coalesce in transform map, shall we have to index those fields as  well in target table? That's the specific question.

Regards

Kirti