Is it possible to create a transform map for table with NO coalesce field.

[hmalhotra22]

I want to create a transform map on the sys_dictionary table where i want to map three fields, however none of those fields are unique so I cannot select any one of them as coalesce. I checked for other fields on the sys_dictionary table that might be having unique values which I can then use in my transform map, but even this is not the case. Any possible solutions for this?

[Dr Atul G- LNG]

Hi @hmalhotra22 

I want to create a transform map on the sys_dictionary table where i want to map three fields, however none of those fields are unique so I cannot select any one of them as coalesce.

I checked for other fields on the sys_dictionary table that might be having unique values which I can then use in my transform map, but even this is not the case. Any possible solutions for this?

Atul: Yes, you can make the filed coalsec. 

[hmalhotra22]

Hi Atul, Surely we can make any field as coalsce but thats not the right thing to do as there might be duplicate values, that is why we always pick unique fields as coalesce such as userid, email, etc, In this case we will never pick a name as coalsce. Therefore not having a unique field might cause some difficulties for which I need a solution.

[Dr Atul G- LNG]

Hi @hmalhotra22 

Got your point, mate. 

Is it possible to create a transform map for table with NO coalesce field.

Atul: Yes , it is possible. 

[hmalhotra22]

Not helpful! But thanks for taking the time out to reply.