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
- 6372 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 convert multiple rows to single row (multiple columns) in informatica
what are the Methods For Creating Reusable Transformations?
In informatics server which files are created during the session rums?
How would you copy the content of one repository to another repository?
How to join three sources using joiner? Explain though mapping flow.
Explain what transformation and how many are there in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How we can create indexes after completing the loan process?
what is unit testing?tell me proceedure
Explain the mapping variable usage example in informatica
What is a joiner transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is update strategy transform?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Can we create a Integration service without a Repository service and vice versa?
