How to setup Coalesce field in robust transform map?

Ravi Gupta1
Tera Expert

Hi,

 

I want to insert/update record from Staging table of robust transform map to two target table.

I have two target table: tableA and tableB.

To update the record in tableA, I have fieldA in staging table.

To update the record in tableB, I have fieldB in staging table.

I wan to create two coalesce field in staging table which can update record of two different table.

Please assist.

 

Thanks

Ravi

 

 

2 REPLIES 2

jtshone
Tera Expert

Hi did you manage to find anything out about this?

 

Hi @Ravi Gupta1 ,

 

Use Unique Input Sets as coalesce in Robust Transform.

 

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

 

Thanks & Regards,

Sumanth Meda