EPM Data Writeback to Two different DB Tables consecutively
We have a requirement where EPM PBCS Data needs to be loaded to two different EBS Staging Tables.
Table One: Week Period, Year, Account, Scenario, Product, Version
Table Two: Week Period
Our requirement is to validate Table Two Week Period Rows and create a EBS Program to capture same Rows from Table One and to load to a different table for additional processing.
I tried using Data Integration Query and Table name parallel but Query taking precedence. I can think of a Target application and to reload Second Table Data using Query method but is there any other way where at Single click, we can perform above requirements?