GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 13 of 631    Print  
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.




  
Total Answers and Comments: 5 Last Update: September 06, 2007   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 15, 2006 13:10:38   #1  
sangroover        

RE: What is Session and Batches?

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.   


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
May 14, 2007 04:25:55   #2  
sanghala Member Since: April 2006   Contribution: 111    

RE: What is Session and Batches?

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


 
Is this answer useful? Yes | No
May 15, 2007 06:27:27   #3  
Goush Member Since: May 2007   Contribution: 2    

Sessions

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.



 
Is this answer useful? Yes | No
July 18, 2007 09:32:04   #4  
selvaraj.durairaj Member Since: July 2007   Contribution: 3    

RE: What is Session and Batches?
Session is a set of instruction when the data moves from source to target.

Batches: It is a grouping of session is called batches

By
Selva

 
Is this answer useful? Yes | No
September 06, 2007 14:04:39   #5  
chandrarekha        

RE: What is Session and Batches?
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


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape