This section outlines three scenarios for using InfoSources. The decision to use an InfoSource depends on how the effort involved in maintaining the InfoSource and any potential changes in the scenario can be minimized.
1. Data Flow Without an InfoSource:
The DataSource is connected directly to the target by means of a transformation.
Since there is only one transformation, performance is better.
However, if you want to connect multiple DataSources with the same structure to the target, this can result in additional maintenance effort for the transformation, since you need to create a similar transformation for each DataSource.
You can avoid this if the DataSource is the same, it just appears in different source systems. In this case, you can use source system mapping when you transport to the target system so that only one transformation has to be maintained in the test system. The same transformation is created automatically for each source system in the production system.
2. Data Flow with One InfoSource
The DataSource is connected to the target by means of an InfoSource. There is one transformation between the DataSource and the InfoSource and one transformation between the InfoSource and the target.
We recommend that you use an InfoSource if you want to connect a number of different DataSources to a target and the different DataSources have the same business rules. In the transformation, you can align the format of the data in DataSource with the format of the data in the InfoSource. The required business rules are applied in the subsequent transformation between the InfoSource and the target. You can make any changes to these rules centrally in this one transformation, as required.
3. Data Flow with Two InfoSources
We recommend that you use this type of data flow if your data flow not only contains two different sources, but the data is to be written to multiple targets that are identical or almost identical. The required business rules are executed in the central transformation so that you only have to modify the one transformation in order to change the business rules. You can connect sources and targets that are independent of this transformation.