HI Experts,
What is BULK mode and NORMAL mode, Which one gives better
performance. How? Please Explain with an example...! It
will help's me a lot.
Thanks In advance.
Answer Posted / kumar
Hi Friends,
Normally we have two types of loading. 1, Normal and 2. Bulk.
1 Normal: in this, data will load record by record and the integration service creates database log and is used in session because IS maintain the session log.
2 Bulk: In this, Data will insert Group of records, obviously bulk load will give better performance.
thanks,
kumar
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What does update strategy mean, and what are the different option of it?
explain one complex mapping with logic? sales project?
Define enterprise data warehousing?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is informatica powercenter repository?
What is meant by lookup transformation? Explain the types of lookup transformation?
How to extract the informatica rejected data?
Which files are created during the session rums by informatics server?
How many ways are there to create ports?
How to elaborate powercenter integration service?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How you prepared reports for OLAP?
What is the cumulative sum and moving sum?