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
- 6122 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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is deployment group?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is confirmed fact in dataware housing?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
explain abt ur project architecture?
What is the difference between informatics 7x and 8x and what is latest version?
Explain about cumulative Sum or moving sum?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Differentiate between Load Manager and DTM?
What is a shortcut and copy in Informatica and how two are different with each other?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How might you approve all mappings in the archive all the while?
Can informatica load heterogeneous targets from heterogeneous sources?
What is xml source qualifier transformation in informatica?
