I am working on a project and can't seem to find the sollution, I hope you can help.
What we want to do is load the product of two ODSses to a new ODS. We have on ODS with customer data and one ODS with financial postings. Some customers have received a posting and some have not, and we want to see all customers with all postings in one view. I have created an infoset with a left outer join and the query works correctly. Now I want to use this data further on in the flow, so load it to a new ODS.
Do you know if there is a simple way of loading the product of two ODSses to a new ODS?
or use an infoset as a datasource for a new ODS?
I hope you can help me with this!