Skip to Content

How to join two datasources with master data

Sep 06, 2017 at 09:15 AM


avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mario Tibollo Sep 06, 2017 at 09:34 AM

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

10 |10000 characters needed characters left characters exceeded