1 |
Toolbar |
Use this toolbar to access commonly performed actions:
- New file button ( ) to create a new job, transformation, database connection, or slave
server.
- Open file button ( ) to open a transformation or job from a file.
- Explore Repository button ( ) to explore the repositories.
- Save button ( ) to save the current transformation or job to a file or
repository.
- Save As button ( ) to save the transformation or job under a different file name or
type.
- Perspectives button ( ) to switch between the different perspectives:
|
2 |
Connect button |
Use this button to access the menu to create and connect to repositories for central storage
of your ETL jobs and transformations. |
3 |
Sub-toolbar |
Use this toolbar to perform transformation or job actions:
- Run button ( ) to run a transformation or job:
- Run: Runs the current transformation or
job from an XML file or a repository.
- Run Options: Sets the Run
Options and then runs the current transformation or job from
an XML file or a repository.
- Pause button ( ) to pause a running transformation or job.
- Stop button ( ) to stop a running transformation or job:
- Stop: Stops the transformation or job
immediately.
- Stop input processing: Stops the input
steps to the transformation or job, while allowing any records already
retrieved or initiated to be processed and then stopped.
- Preview button ( ) to run the transformation in preview mode to examine the rows
produced by the selected steps.
- Debug button ( ) to run the transformation in debug mode to troubleshoot execution
errors.
- Replay button ( ) to replay the processing of a transformation.
- Verify button ( ) to verify the transformation.
- Analyze button ( ) to run an impact analysis on the database.
- SQL button ( ) to generate the SQL that is needed to run the loaded
transformation.
- Explore DB button ( ) to launch the Database Explorer to perform
actions such as preview data, run SQL queries, and generate DDL.
- Results button ( ) to show the Execution Results
pane.
- Lock button ( ) to lock the transformation.
|
4 |
Explore pane |
Use this pane to access the Design and
View tabs:
- The Design tab provides a list of steps or entries that
are used to build transformations or jobs.
- The View tab provides information about available
database connections and the steps and hops used for the transformation or
job.
|
5 |
Canvas |
Use this canvas for designing and building transformations and jobs for the ETL
activities you want to perform. |