Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 8 Answers
- 15235 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / pardhu
when u configure the session with the type normal the I.S
writes the data records to database log before inserting the
rows into target. when u configure the session with the type
bulk the I.S bypasses the database log it inserts the
records directly into target. In normal mode session
recovery is possible but in bulk mode session recovery is
not possible. bulk mode improves the performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the scenario which compels informatica server to reject files?
tell me about your project functionality
tell me 5 session failure in real time how can you solve that in your project?
where to store informatica rejected data? How to extract the informatica rejected data?
What is joiner change?
What is data transformation manager process?
can u give example for factless fact table
What is a joiner transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Scheduling properties,whats the default (sequential)
What do think which one is the better joiner or look up?
Explain the code page compatibility?
What are the data movement modes in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
