I have layer1 and layer2 QVD. I have applied the incremental load on layer1. However, there is a requirement to apply the incremental on the layer 2 QVD.
In the layer2 QVD, there is a transformation logic as per the business need.
You need to know what the unique key is from table 1 and 2 and they need to be available in both. If you can identify what has changed in layer 1, based on the unique key you can update (incrementally) the QVD in layer 2.
Regardless on which layer an incremental loading should be implemented - the logic and syntaxes follows the same approach.
Therefore you could start with a copy & paste of your method in layer 1 and doing the appropriate adjustments. If your second layer looked quite different to the first one it could mean that your second layer may be the second step in your workflow but not mandatory a pure second layer else rather a second/third/... in combination layer. In this case you should consider to divide your task into more working steps and/or layers to get an easier handling within the development and update process.
