I am running a DMS migration task,
- Source - MongoDB
- Target - Postgresql
One of the integer fields in mongo has 5% values in the string and the rest values in integer data type. After migration to Postgres, the String values are as it is and all integer values in that column become null.
I also tried adding a transformation rule where I changed that column data type to int2, int4, and string but still, only 5% of data comes with the changed data type but the rest of the values are NULL which were integer types in mongo DB.
How will I be able to change all values to Integer type or all to string type? As I do not want to lose any data.
