Building a data entity with multiple data sources

We could also create a data entity where we include multiple data sources. Here our data entity takes care of all integrity constraints and validation and creates records in related tables if it does not exist. Let us take, an example of inventory breakdown, where we create an inventory site, warehouse, location, zones, aisle, and so on. We could create a data entity, which encapsulates all these tables, and a flat file import could create related records in all these tables.

How to do it...

Carry out the following steps in order to complete this recipe:

1. Add a new data entity in the project and name it PacktInventBreakDown.

2. A Data Entity Wizard will be launched, as shown...