How to reduce the manual mapping in mapper? without using SmartLink option

[Surendar]

• We have a scenario like have to map 250+ columns from source to target
• The source and target may or may not have same case like(upper,lower etc)
• Using SmartLink able to map only limited columns but not entire columns
• How to reduce manual mapping in mapper? If any spacial way for this?

Kindly suggest me. Thanks in advance.

[nganapathiraju]

There is no real special way but before we take this on further, did you use all available options?

• Did you use the pass through if that helps in case certain mappings match.
• Use mappings only when transformations are required (any transformation for that matter)
• Case sensitiveness may not matter for database columns after all.

What is your use case?

[cesar_bolanos]

Sometimes we use JSON generators for this. We generate the direct mappings on the generator using a spreadsheet or editor, then a mapper for the simple ones

[murphy-brian]

Can you elaborate on this? I am wresting with how to generate Target Schemas to simplify mappings and also standardize outputs