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 / sri
Bulk mode always create a session log and is used in
session recovery for eg . if we opt for bulk mode, if the
session fails after inserting 9000 rows on total of 10,000
rows (commit interval is after 10,000 rows) then we can
recover 9000 rows and can satrt the session for the rest of
row
In normal mode session log is not created and hence it is
faster than bulk mode .. Session recovery is not possible
in normal mode ..
| Is This Answer Correct ? | 4 Yes | 53 No |
Post New Answer View All Answers
explan ur project architecture?
How to do unit testing in informatica? How to load data in informatica ?
What are the prerequisite tasks to achieve the session partition?
which one is better performance wise joiner or look up
What is the difference between stop and abort in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the different transaction levels available in transaction control transformation?
What are connected or unconnected transformations?
As union transformation gives UNION ALL output, how you will get the UNION output?
explain about unit testing? in real time?
Where is metadata stored?
How to delete duplicate row using informatica?
What are the new features of informatica 9.x developer?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
pmscmd startworkflow -sv