on 09-06-2017 10:15 AM
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.
add the company code and employee name as navigational attributes of employee ID. create a transformation from ZDS_COM_EMP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.