Prior to posting a question here, I searched the entire repository to find a solution to my question but no luck!! (may be my poor searching skills
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Question:
We are trying to build a framework where a single job has to be build which should pick up the fields from the table dynamically. This job will pull the data based on SQL queries and load into target table with some intermediate joins and transformations also.
I believe, for simple data extraction and load, we can use RCP functionality.
But, in this case where transformations and joins will differ table to table, can we go still go with RCP?
Also, we need to use the Optim's Datamasking pack within the same job and the fields which are to be masked differs table to table.
Can you please suggest a solution for this? Appreciate you time for reading this.
Thanks!!