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
- 6074 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 differentiate between the active and passive transformations?
Explain sql transformation in script mode examples in informatica
What is the scenario which compels informatica server to reject files?
How to extract sap data using informatica?
Parameter and variable differences
What are the main features of Oracle 8i with context to datawarehouse?
What is a joiner transformation and why it is an active one?
What are the components of workflow manager?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How can we create index after completion of load process?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the basic requirements to join two sources in a source qualifier transformation using default join?
In informatics server which files are created during the session rums?
What is aggregate cache in aggregator transformation?
without table how to come first record only in oracle?
