You can access the data extraction definitions by accessing the AFCS User Interface. When you sign on to the application, you are directed to the Home Page. On the Left Hand Side menu, click Data Extraction, which will show basic details of the Extract definitions. AFCS supports user-configured extraction of data from Staging and Results entities via Connectors.
NOTE:
If the Extraction Entity contains the As Of Date column, the data will be filtered based on the PMF execution date. When no date is selected during PMF Execution, the data will be filtered based on the current date.
As the PMF execution date will be picked up as the default date for the extraction, you are not expected to provide a filter on As of Date during connector creation.
NOTE:
Data Extract in AFCS supports file size upto a maximum limit of 2 GB.
To add a Data Extraction, follow these steps:
1. From the AFCS Home page, select Data Extraction.
The Summary page is displayed with a list of data extraction definitions.
2. Click Add to add a new Data Extraction.
The Specify Details Window is displayed.
3. Enter the Name for the Data Extraction.
For Example: Extract CASA.
4. Enter the Description for the Data Extraction.
This field is optional.
5. Select the Grain from the dropdown option.
For Example: Customer Account.
6. Select the Entity from the dropdown option.
For Example: Casa
7. Enter the required filter expression for the Data Extraction. In addition you can also add Parameters.
This field is optional.
For Example: [Casa].[Account or Contract Number] is not null.
This filters only the rows where the account or contract number is not null.
8. Click Validate to verify the correctness of the SQL Expression and click OK.
The filter expression is displayed in the Expression text box.
9. Navigate to Select Attributes page.
The Attributes list displays the list of the attributes that can be associated with the Data Extraction. The attribute list shows the combined attributes for all the Tables selected.
10. Select the attributes and click the OK button.
You can select and unselect the attributes by clicking on the respective icons. Also you can rearrange the attributes in the Selected Attributes section by drag and drop.
NOTE:
You can select a maximum of 998 attributes.
11. Navigate to Describe File page.
12. In the Specify Data file names, enter the file name. This is a mandatory field.
For example: test_file_data.txt
NOTE:
The file extension must be either .txt or .csv.
13. Select Column delimiter from the dropdown option.
For Example: Comma
14. Specify Text qualifier in the textbox.
For Example: Double quotes can be used, prefixed, and suffixed with text
15. Select file format from the dropdown option.
For Example: Fixed Length or Delimited.
16. Select Record delimiter from the dropdown option.
For Example: Unix
17. Toggle the Header button if you want a header to be displayed in the extracted file.
This field is optional.
NOTE:
The extracted file will show Result, Dimension, Integration, and Staging tables. Currently, the Processing layer tables are not supported.
In case two physical entities contain the same logical name, the order of preference for the entity will be:
1 - Result
2 - Dimension
3 - Integration
4 - Staging
18. Click Save.
19. After the Data Extraction is saved, the PMF process needs to be configured and executed. For more details, see Executing Connector using Process Modelling Framework.
The Data Extraction file is created.
20. Download the file from the File Operations screen. For more details, see File Operations.