Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / sasikumar_bes

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.

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain your project of banking domian.

1619


Scheduling properties,whats the default (sequential)

1911


How we can create indexes after completing the load process?

1126


hi real timers . iam waiting for ur reply regarding ETL TESTING

2218


What does role playing dimension mean?

1014


How will the document be delivered to me?

1033


Explain how to import oracle sequence into informatica?

968


Explain why we use partitioning the session in informatica?

1029


Explain joiner transformation in informatica

1088


Can we get 1st record through Informatica(without sequence number).

1431


How is union transformation utilized?

964


What is the use of code page?

1026


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10643


What are some examples of informatica etl programs?

903


How to go to the older version for a mapping?

1044