Interested to Buy Any Domain ? << Click Here >> for more details...
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
- 3 Answers
- 6202 Views
- I also Faced
- E-Mail Answers
Answer Posted / dbseeker
For History Load, generally the data is bulk loaded because the cost of indexes on the table is skipped when bulk loading is done as indexes on the target table are not allowed for bulk load.Once the data is loaded then the indexes are created. This way we could load the data into the target much faster.Also bulk load would not write the rows in the roll back segment.The time taken to write into roll back segment is also saved.Hence performance improved.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
what is the hint? how to use it to reduce the query processing in program?
How can repository reports be accessed without sql or other transformations?
what is size of u r database?
what is the Default Source Option For Update Strategy Transformation?
Which development components of informatica have the highest usage?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain the features of connected and unconnected lookup.
How to extract the informatica rejected data?
Explain direct and indirect flat file loading (source file type) - informatica
Separate from an archive server and a powerhouse?
How are indexes created after completing the load process?
where to store informatica rejected data?
What is meant by a domain?
What are the steps involved in the migration from older version to newer version of Informatica Server?
