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
How many transformations can be used in mapplets.
What are the differences between source qualifier and joiner transformation?
How will the document be delivered to me?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is rank transformation in informatica
Write the unconnected lookup syntax?
Enlist the differences between database and data warehouse.
Explain sessions. Explain how batches are used to combine executions?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to generate or load values in to the target table based on a column value using informatica etl tool.
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to extract the informatica rejected data?
How can we remove the duplicates from flat file source?