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...

Read Best Answer

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.

amolrenose

 Profile Answers by amolrenose Questions by 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.

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

1. ASCII mode2. UNICODE mode

Improve Answer