Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - Explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ?




1363
views
asked marvit September 20, 2014 08:05 AM  

Explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ?


           

1 Answers



 
answered By vishnoiprem   0  
Normal loading:the integration service create the data base log before loading data into the the target data base.so the integration service perform roll back and session recovery.
if we are running the session in normal target load mode we can recover the session if the output being loaded to the target is deterministic in nature - this is relay a helpful feature with the applications handling RealTime data.

Bulk loading:the integration service in work the bulk utility when bypass the data base log this is improves the performance data loading this is not perform rollback
mention- apart from logging differences there is a crucial diffrence - if we are running the session in bulk target load mode we cant recover a session from the same point when we run it for the next time.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert