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
- 12397 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
What are the different lookup cache(s)?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Why union transformation is an active transformation?
Why filter transformation is an active one?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to create the source and target database connections in server manager?
Why is sorter an active transformation?
What are the components of workflow manager?
Explain the types of transformations?
what is the -ve test case in your project.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
