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
- 14609 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajasekar genji
yes Archie is right has the name indicates bulk, data will
loaded has bulk we cannot recover in bulk. In Normal mode
data will be loaded one by one so data can be recovered.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / priya
Normal mode creates a session log and is used in session
recovery.
But in Bulk mode its faster in peformance but its not
possible to create a session recover.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / nivas
Target Loading types are mainly catagorized into 2 types
1.Normal Loading
2.Bulk Loading
In the permoance Point of view Bulk Loading is better than
Normal Loading but session recovery is not possible because
of it's Byparses the session log.
Normal loading create the session log for session recovery.
Using Normal Loading only we will get session recovery.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / 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 |
Answer / guravareddy
When u chose target load type Normal mode the integration service creates database log and is used in session
recovery.
Where as in bulk mode the integration service by pass load the data into target, but its not
possible to create a session recover.
But in Bulk mode its faster in peformance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / 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 |
How can you validate all mappings in the repository simultaneously?
Write the different tools in the workflow manager?
What do you mean by channel change?
What is the difference between Bitmap and Btree index?
What is surrogate key?
Define error Threshold?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
explain about session partitions ?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
What are Dimensional table?
Teradata 
