Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 3 August 2014

Batches in Informatica

By on 10:24:00

What are Batches ? Types of Batches and their uses?

Batches are group of sessions executed in serial or parallel by the Informatica Server.

Two Types of Batches
1) Sequential Batch   :  Run the batched Sessions one after other.
2) Concurrent Batch  :  to start  the all Sessions in batch at once.

Batches are used to improve performance or to ensure targets load in a set order.
Default is  Sequential Batch.
How you start , stop, schedule, create , edit batch?
Using Server Manager. Or pmcmd command

Is it possible to copy or abort batches?

Batches in Informatica
Batches in Informatica

What command is used to start session or batch?
Pmcmd      if it returns 1 session is failed
Informatica server removes failed batches from schedule.

What is role of Sequencial Batch and Concurrent batch which is useful?
Using Sequencial Batch the Informatica Server execute the next session only if previous session is completed.
It can configure next session only if previous session complete. If first session fails informatica server marks both session and entire batch failed, then remove batch from schedule.

Using Concurrent batch, informatica server starts all sessions within batch at the same time. If the time on informatica server is limited this concurrent batch is useful.  It reducing time to run sessions. you increase the chances of completing the sessions within a given time period.

If Session sends 40millions of data to staging area. Instead of running large session  we can improve session performace by divding one large session into 40 separate sessions running them concurrently in a batch.

What are diff. Between sequencial batch and concurrent batch?

Sequential Batch

Concurrent Batch
1) if the first session fails after correcting the session it execute the next session

1) if first session fails Informatica Server Ignores the first one and processing the next session.
2) you can recover data from the session that failed and run the remaining sessions in the batch.
2) if all sessions in a concurrent batch fail, you might want to truncate all targets and run the batch again.

What is the use of Batch Parameter File in Batch ?
Enter parameter file in batch property sheet to override parameter files used by sessions contained in batch.
To override session parameter file we use Batch Parameter File.


Post a Comment


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)