Five Stars

Hierachy in Data Model and Import Data to the models

Hi All,


I am trying to build a Data Models with two Data Entities: Let's say Customer and Order


Customer table contains all the information about that customer.

In Order table, I am trying to have a Customer column. But instead of having an Customer_Id like normal database tables would have, I would like to have a Customer object so that all the fields of customers would also be visible through Order.

(Looks like it can be done by Add a new Business Element -> Reference Name: Customer)


I am wondering if this can be done in Talend. And if I want to import data, how shall I map the original data fields to the data entities I have been created? Currently I am only able to match column-by-column.


Thank you very much.


  • MDM