In this exercise, you will create an extract service based
on the data specified in an access definition. Use an extract service
to copy a set of related rows from one or more tables and save the
rows to an extract file.
To create an extract service:
- Expand the Tutorial folder in the Directory Explorer, right-click Extract
Services, and click . The New Service wizard opens.
- On the Enter a Service Name and Select a Service Type page,
do the following steps:
- In the Name field, enter SAMPLE.EXTRACT.
- In the list of service types, select Extract.
- Click Next.
- On the Select an Access Definition page, click Select
an access definition. The page displays
a list of access definitions.
- From the list, select SAMPLE.AD. Click Next.
- On the Enter a Target File Name page, enter SAMPLE_EXT in
the Extract file name field.
- Click Finish.
The new extract service displayed in the Extract Service
Editor. You can use this service to create an extract file for a convert,
insert, or load service. You can also use the file to create a column
map or table map.