Skip to Content
19
Nov 16, 2022 at 02:57 PM

SAP DWC : Multiple intermediate target in Data Flow and Graphical View ?

539 Views Last edit Jan 16, 2023 at 01:51 PM 2 rev

Hello Experts,

In SAP Data Warehouse Cloud,

in Data flows and Graphical Views it seems not possible to have multiple target per intermediate node.

for example a join/union/projection/table can only be used as input in 1 join/union/projection/table.

If you have multiple "split and union" in the logic flow, this limitation (compared to hana modelling or BODS) will have the effect of explode exponentially the object needed in a dataflow or a view and create multiple maintenance spots due to duplicated object logic.

The only workaround seems to define a view for every split.
But this reduce dramatically the readability of graphical objects as you need to swich between different objects/layer.
Is there a solution ? or will there be a solution in near future?

Regards