What are 2 modes of data movement in Informatica Server?

The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.

a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)

b) ASCII - IS holds all data in a single byte

The IS data movement mode can be changed in the Informatica Server configuration parameters. This comes into effect once you restart the Informatica Server.

  • Interview Candidate
  • 14
  • 28531

Editorial / Best Answer

Answered by: purushotham

  • Aug 9th, 2005

the two types of modes are: 
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
 
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

Showing Answers 1 - 14 of 14 Answers

purushotham

  • Aug 9th, 2005
 

the two types of modes are: 
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
 
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

sangeetha

  • Sep 25th, 2005
 

the 2 modas are

Unicode mode

Ascii mode

  Was this answer useful?  Yes

sastry_66

  • Feb 27th, 2010
 

There are 2 modes of data moment:
1. Normal mode
2. Bulk mode
Normally if there are no data constraints (key constraints) we will use bulk mode otherwise we use normal mode. 

  Was this answer useful?  Yes

amolrenose

  • Sep 18th, 2011
 

Data Movement Modes

1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.

Data Loading Modes

1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded.

  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