problem with infoset

[Former Member]

We have an infoset with sales order ,delivery and billing.

Sales order is mapped with billing and delivery ods with left outer join. can we join delivery to billing in the same info set.

The problem is sales order ods get correct data.

In delivey and billing we are getting data from other systems.

How to rectify this .

Please suggest.

[yogesh8984]

Hi,

The decision will purely base on how you are getting the data in Delivery and Billing ODSes. If you join them, you will get the data in the output only for the records which are having its presence in both the ODSes. But there is a every chance that the record in Delivery ODS will not be present in Billing ODS each time.

Using MultiProvider can be a better option.

Regards,

Yogesh.