Transform map Not working as some data in staging table still in pending state.

[HarikrishnaP161]

Transform map Not working as some data in staging table still in pending state. i have enabled the run business rule checkbox in transform map. Need some help here.

[QuynhT]

If records in the staging (import set) table are still in Pending, it means the transform has not completed or some rows are being skipped. Enabling “Run business rules” alone will not move records out of the Pending state.

Recommended steps:

• Stop or temporarily disable the transform map that is currently pending.
• Review the transform map configuration (active status, field mappings, coalesce settings, and any transform scripts).
• Check Transform History and Import Set Row errors to see if records are being skipped (for example, due to ignore = true).
• Once verified, reload the data and re-run the transform from the Load step, instead of reusing the existing staging table.

This approach helps avoid partial or inconsistent transforms caused by reprocessing pending import set rows.

[QuynhT]

If records in the staging (import set) table are still in Pending, it means the transform has not completed or some rows are being skipped. Enabling “Run business rules” alone will not move records out of the Pending state.

Recommended steps:

• Stop or temporarily disable the transform map that is currently pending.
• Review the transform map configuration (active status, field mappings, coalesce settings, and any transform scripts).
• Check Transform History and Import Set Row errors to see if records are being skipped (for example, due to ignore = true).
• Once verified, reload the data and re-run the transform from the Load step, instead of reusing the existing staging table.

This approach helps avoid partial or inconsistent transforms caused by reprocessing pending import set rows.