Help me please
I would like to report a bug. I am evaluating ETL to see if I can connect to my company's SAP file and validate and transform data automatically instead of manually.
My company provides all of our business units access to the same data file. However additional data fields are sometimes added to the file.
I spent hours building my validations and transformations in ETL but when I went to run the program, it unlinked all of my trans and vals because a new field had been added to my source file.
The data field names between my source file and target file did not change, there was simply one extra field added to the source file.
All of my work was trashed.
Shouldn't ETL maintain the links between the source and target files if the names of the fields are always the same?
I think the lack of this capability would probably eliminate a lot of users like my self who are trying to find a relatively inexpensive ETL to work in a department and not working on enterprise scale.
Any chance this is an easy fix?
Sincerely,
Mike
