Forum Discussion

Surendar's avatar
Surendar
Contributor
8 years ago

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

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...
expression_language
mapper
transform
cesar_bolanos's avatar
cesar_bolanos
New Contributor
8 years ago

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's avatar
    murphy-brian
    New Contributor III
    8 years ago

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