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
- 6256 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 do you convert single row from source into three rows into target?
What do you mean by filter transformation?
What are the tasks that source qualifier perform?
What are the databases that informatica can connect to windows?
What is informatica metadata and where is it stored?
What are batches?
Explain the tuning lookup transformation - informatica
How we can create indexes after completing the load process?
Is there any way to read the ms excel datas directly into informatica?
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
What are the types of lookup transformation?
What is the benefit of partitioning a session?
What are the types of caches in lookup?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Why filter transformation is an active one?
