cancel
Showing results for 
Search instead for 
Did you mean: 

How to join two datasources with master data

Former Member
0 Kudos
i'm carrying on some modification based on datasources which have been created.

ZDS_COM_EMP: employees in a company
fields: Company Code, Employee ID, Employee Name
ZDS_EMP_WRKCTR: employee assigned to work center of a plant, one employee can assign to multiple work center;
Fields: Plant, Work Center, Employee ID;


now i want to join these two datasource based on Employee ID to know within a company / plant / work center, who are the employees assigned.


May I know how should i design the data flow? what type of target object should i choose?
sorry that, I'm still new to BW.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186445
Active Contributor
0 Kudos

add the company code and employee name as navigational attributes of employee ID. create a transformation from ZDS_COM_EMP.