I have a requirement in which i need to move the data from cube A(source) to cube C(target) and have following options:
1. Use write_back_init in the source application (cube A) for writing data in target application (cube C). This is basically pushing of data after performing the mapping/allocation based on the target application structure.
2. Use UJQ_RUN_RSDRI_QUERY in target application (cube C) to lookup the transactional data in source application (cube A) and perform mapping/allocation and then write them within the target application.
Currently i have 2 packages based on approach 1 moving data from source to target.
1. cube A --> cube C
2. cube B --> cube C
With option 2 i can go with:
cube C performing lookup on cube A and cube B in a single object and writing them within the cube C itself.
Please let me know your thoughts if you see any pros and cons in both the approaches.
Thanks in Advance!