You create transformations for the attributes and texts of characteristic Product (ZD_PROD).
The master data for the characteristics Product Group and Channel will be created later directly in the system. No transformations are therefore required in our scenario for these characteristics.
...
1. You are in the Modeling functional area of the Data Warehousing Workbench.
2. Choose InfoProvider.
3. Choose Create Transformation... from the context menu at the symbol for texts under your InfoObject Product (ZD_PROD).
4. Select object type DataSource as source of the transformation and select your DataSource for texts ZD_PROD_TEXTS and source system PC_FILE.
5. Choose Create Transformation.
The maintenance screen for the transformation appears. The fields of the DataSource are displayed at the left and the rule group with the target InfoObjects at the right.
6. With the mouse, connect the DataSource fields with the target InfoObjects as follows:
DataSource Field |
InfoObject |
PRODID |
ZD_PROD |
PRODDESC |
0TXTMD |
LANGUAGE |
0LANGU |
7. Activate your transformation.
8. Exit from the transformation maintenance screen.
9. Choose Create Transformation... from the context menu at the symbol for attributes under your InfoObject Product (ZD_PROD).
10. Select object type DataSource as source of the transformation and select your DataSource for attributes ZD_PROD_ATTRIBUTES and source system PC_FILE.
11. Choose Create Transformation.
The maintenance screen for the transformation appears.
12. With the mouse, connect the DataSource fields with the target InfoObjects as follows:
DataSource Field |
InfoObject |
PRODID |
ZD_PROD |
PG_ID |
ZD_PGROUP |
CURRENCY |
0CURRENCY |
PRICE |
ZD_PRICE |
13. Activate your transformation.
You created the transformations for the master data for characteristic Product and have now completed all preparation for creating and executing the load processes for the attributes and texts of characteristic Product.
Creating Transformations for InfoCubes