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.
Carry out the following steps in order to complete this recipe:
- Add a new data entity in the project and name it
PacktInventBreakDown
.
- A
Data Entity Wizard
will be launched, as shown in the following screenshot:
- Next you need to select
all/required fields
fromWMSLocation
.
- Click on the
Add data source
button and selectRelation InventLocation
.
- Select
Invent location
from the node at the right ofWMSlocation,
as shown in the next screenshot. Add new data source...