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
nganapathiraju's avatar
nganapathiraju
Former Employee
8 years ago
Copy Link

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?