adding one field to a mapped SalesForce object causes the transformers mappings to be scrambled...

More
8 years 3 months ago #13127 by dmart024
Hi,

This has happened to me several times already. When a field is added or removed from a mapped object, the transformer mappings are remapped randomly. As we are adding and removing fields to the SalesForce Account object, this happens frequently. It happened yesterday when I switched the SalesForce connection between our development environment and production. I wanted to cry as there are about 80 mappings that have to be redone. Guess what? Our development and production environments are not 100% in sync.

It appears that the mappings are positional in nature. Why not use the field names to maintain the mappings?

Don

Please Log in or Create an account to join the conversation.

More
8 years 3 months ago #13128 by Peter.Jonson
Yes mapping is position based.

The problem you are having can be sold with one click
Add another trahsformation before datawriter and click Automap

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.