I have to use multiple table in more than 30 mappings.
These mappings include some operator like joiners, splitter and expressions.
The problem is that I have to change the table structure like adding new columns.
This happens quite often - every 2 month or so.
It is most of the time one or two new columns.
The result is that I spent a lot of time synchronising the tables and adding the new columns the joiners, splitter and so on for every mapping which uses the tables.
I was asking myself if there is an other way to do this.
I thought that I maybe can use a view or a mat view.
Or is there some other way (or operator) to realise this kind of task.
I you have any ideas or suggestions please let me know.
You could add 100+ columns to start with and have them in your mappings for future reference or you could create a OMB script for your mappings and use that for adding columns but the real question is why are you adding new columns every 2 months?
our client decides every now and then that he needs new data - so new fields.
I am not allowed to just add 100+ fields.
Can you tell me more about the OMB scripting? Are there some manuals available some were?
Is it possible to change the mapping including all operators with a script?