- Posts: 86
- Thank you received: 0
adding one field to a mapped SalesForce object causes the transformers mappings to be scrambled...
8 years 3 months ago #13127
by dmart024
adding one field to a mapped SalesForce object causes the transformers mappings to be scrambled... was created 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
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 3 months ago #13128
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic adding one field to a mapped SalesForce object causes the transformers mappings to be scrambled...
Yes mapping is position based.
The problem you are having can be sold with one click
Add another trahsformation before datawriter and click Automap
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.