You create a transaction data DataSource to copy the sales data from the file to the BI system.
File source system PC_FILE exists.
1. In the Modeling area of the Data Warehousing Workbench, choose DataSources.
2. In the context menu of your application component, choose Create DataSource...
3. In the next screen, enter ZD_SALES for DataSource and select Transaction Data as the Data Type DataSource.
4. Choose Transfer.
The DataSource maintenance screen appears.
5. On tab page General Info. enter Sales Data as Short description.
6. Go to the tab page Extraction and define the following:
Field |
Entry/Selection |
Adapter |
Load Text-Type File from Local Workstation |
File Name |
File of your workstation, select the file Tutorial_Trans.csv. |
Header Rows to be Ignored |
2 |
Data Format |
Separated with Separator (for Example, CSV) |
Data Separator |
; |
Escape Sign |
“ |
Number format |
Direct Entry |
Thousands Separator |
. |
Decimal Point Separator |
, |
7. {0>»
8. <}0{>
9. Go to tab page Proposal and choose Load Example Data to create a proposal for the DataSource.
11. Go to the Fields tab page.
In the dialog box, choose Yes.
The field list of the DataSource is copied from the Proposal tab page.
12. Make the following changes and enhancements:
...
a. Change the data type for the following fields from CHAR to...
Field |
Data type |
CALENDERDAY |
DATS |
QUANTITY |
QUAN |
UNIT |
UNIT |
REVENUE |
CURR |
CURRENCY |
CUKY |
b. Under curr/unit, enter UNIT as the name of the referenced currency/unit field for the field QUANTITY and CURRENCY for the field REVENUE.
c. Change the Format for the field REVENUE from internal to external.
13. Activate the DataSource.
14. Go to the tab page Preview and check the data before the actual load process by choosing Read Preview Data.
You created the DataSource for the sales data. At activation, a table is created for the DataSource in the entry layer of the BI system, the Persistent Staging Area (PSA), and the data is stored there during the transfer.
Creating Transformations for Master Data of Characteristic "Product“