Sessions

1

• Sessions
• And
• Working with Sessions

2
Agenda

• Session overview
• How to create a Session
• Editing a Session

3
Session

• A session is a set of instructions that tells the
  Power Center Server how and when to move data
  from sources to targets
• A session is a type of task
• To run a session, you must first create a
  workflow to contain the Session task

4

• Can create a reusable Session task in the Task
  Developer
• Create non-reusable Session tasks in the Workflow
  Designer as you develop the workflow

5
Steps to Create a Session Task

• In the Workflow Designer, click the Session Task
  icon on the Tasks toolbar.
• or Choose Tasks-Create. Select Session Task
  for the task type.
• Enter a name for the Session task.
• Click Create. The Mappings dialog box appears.
• Select the mapping you want to use in the Session
  task and click OK.

6
Steps to Create a Session Task

• Click Done. The Session task appears in the
  workspace

7
Editing a Session

• You can edit session properties at any time. The
  repository updates the session properties
  immediately.
• If the session is running when you edit the
  session, the repository updates the session when
  the session completes.

8
Editing a Session

• The session has the following tabs, and each
• tab is having multiple settings
• General tab
• Properties tab
• Config Object tab
• Mapping tab
• Components tab
• Metadata Extension tab

9
General tab

• By default, the General tab appears when we edit
  a session task
• We can rename the session task and enter a
  description for the session task

10
General tab

• Rename
• Description
• Mapping name
• Server
• Other properties

11
Properties

• General options
• Performance
• General Options
• - General Options settings allow you to
  configure session log file name, session log file
  directory, parameter filename and other general
  session settings

12
Properties

• Performance
• DTM Buffer size
• Collect Performance Data
• Incremental Aggregation

13
Config Object tab

• Commit and load settings, log options, and error
  handling settings
• The Workflow Manager allows you to create a
  reusable set of attributes for the Config Object
  tab
• Or, you can specify the default session
  configuration object called default_session_config
  

14
Config Object tab

• Advanced.
• Advanced settings allow you to configure
  constraint-based loading, lookup caches, and
  buffer sizes
• Log Options.
• Log options allow you to configure how you
  want to save the session log.
• Error Handling. Error Handling settings allow you
  to determine if the session fails or continues
  when it encounters pre-session command errors,
  stored procedure errors, or a specified number of
  session errors.

15
Mapping Tab

• We can configure the following nodes
• Connections
• Displays the source, target and lookup
  connections.
• You can choose connection types and connection
  values
• Sources
• The Sources node lists the sources used in the
  session and displays their settings

16
Mapping Tab

• Targets
• To configure the settings of a specific target
• Transformations
• Used to override the properties that you
  configured in transformations in the mapping.
• - The attributes you can configure depends on
  the type of transformation you select

17
Components Tab

• Pre-session shell commands
• Post-session commands, and
• Email messages if the session succeeds or fails

18
Metadata Extensions Tab

• The Metadata Extensions tab allows you to
  create and promote metadata extensions

19
Thank you