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
Explain the tuning lookup transformation - informatica
Does an informatica transformation support only aggregate expressions?
What is sq transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Is it possible to create multiple domains on a single Informatica server?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How many ways a relational source definition can be updated and what are they?
How to call shell scripts from informatica?
What are the different versions of informatica?
How do you use reject loader.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How to extract sap data using informatica? What is abap? What are idocs?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to extract sap data using informatica?
What is an expression transformation?