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 / anju

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

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where are the source flat files kept before running the session?

1011


What is a dimensional model?

927


What is a filter transformation and why it is an active one?

906


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1033


What are data-driven sessions?

1143


What is domain in terms of informatica?

953


What is workflow monitor?

997


How do you convert single row from source into three rows into target?

1091


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1133


What are the various types of transformation?

1094


In informatics server which files are created during the session rums?

1063


Performance tuning in UNIX for informatica mappings?

2506


Can informatica load heterogeneous targets from heterogeneous sources?

1118


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1195


What is target designer and target load order?

1051