I have a dataflow which has 3 paths ... 2 paths are mergeed and joined with other path ....each source has 100+ crore of data .....what is the best way to split the data flow in to multiple[ with intermediate table as target ]data flows to reduce complexity and improve performance ....
S1 ---- transform ----------transform with group by ......transform with lookup
] merge ---------------------------- >
S2 ---- transform ----------transform with group by ......transform with lookup ] --------> target 1
S3 ---- transform ----------transform with group by ......transform with lookup --------------------------------------------->
=========================================
is there any standerd from SAP to split the data flow into multiple data flows to reduce the complexity and for good readability and for improving performance. ...