What is Session and Batches?

Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches :

Sequential - Run Session One after the Other.concurrent - Run Session At The Same Time.

  • Interview Candidate
  • 9
  • 24625

Editorial / Best Answer

sanghala  

  • Member Since Apr-2006 | May 14th, 2007

Session:  A session is a set of commands that describes the server to move data to the target.

Batch :  A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc..,)

There are two types of batches in Informatica:

1. Sequential: When Data moves one after another from source to target it is sequential

2. Concurrent: When whole data moves simultaneously from source to target it is Concurrent

Showing Answers 1 - 9 of 9 Answers

sangroover

  • Feb 15th, 2006
 

Session in Oracle is in simple is when you logon into Oracle everytime it is a session.

Batch as it can be defined as a group of something.   

  Was this answer useful?  Yes

sanghala

  • May 14th, 2007
 

Session:  A session is a set of commands that describes the server to move data to the target.

Batch :  A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc..,)

There are two types of batches in Informatica:

1. Sequential: When Data moves one after another from source to target it is sequential

2. Concurrent: When whole data moves simultaneously from source to target it is Concurrent

Goush

  • May 15th, 2007
 

A session is a set of instructions that tells the Integration Service how and when to move data from sources to targets. A session is a type of task, similar to other tasks available in the Workflow Manager. In the Workflow Manager, you configure a session by creating a Session task. You can run as many sessions in a workflow as you need. You can run the Session tasks sequentially or concurrently, depending on the requirement.


When you create a Session task, you enter general information such as the session name, session schedule, and the Integration Service to run the session. You can also select options to run pre-session shell commands, send On-Success or On-Failure email, and use FTP to transfer source and target files.


chandrarekha

  • Sep 6th, 2007
 

Session is a set of instructions that relates to extraction, transformation and loading. Session is a task that relates to data acquisition.
There are two types of task
Reusable task
Non reusable task

Batch :
Batch is a group of sessions, There are three types of batch
Sequential batch
Parallel batch
Control flow

  Was this answer useful?  Yes

Surya_prakash

  • Feb 10th, 2011
 

A session is a task that runs mapping to perform ETLA session to a pointer to the mapping. A session calls mapping from repository. Two types of batch processing.


1) Parellel Batch Processing: All session task start executing at the same point of time.


2) Session batch processing: Sessions executes one after another.

  Was this answer useful?  Yes

Ramana Kummari

  • Jul 11th, 2011
 

session :session is set of instructions ,its main use of to get date  from source to target  with informatica.

  batches means group sessions is called batches.it is two types 1,sequential,2.concurrent
   sequence means  executs one after another.
   concurnt means  all session executes at a time 

  Was this answer useful?  Yes

ravindra

  • Jul 15th, 2011
 

session is an object of repository,which instructs the informatica server(integration service)to execute the mapping with given database connection's...

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions