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

Informatica - What happens if you increase commit intervals and also decrease commit Explain grouped cross tab?




796
views
asked marvit September 20, 2014 08:04 AM  

What happens if you increase commit intervals and also decrease commit Explain grouped cross tab?


           

1 Answers



 
answered By vishnoiprem   0  
if commit interval is set to high value, performance will be high. if commit is given for every 1000 rows say for eg,it will affect the performance badly

if you have increased your commit interval to ~25000 rows the session will run faster but when your session fails at 24000th record you will not have any data in your target.

When you decrease your commit interval to ~10000 rows your session will be slow when compared to previous but if the session fails at 24000th record you will lose only 4000
records.
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