Informatics optimization: PL/SQL mappings

The following should be the configuration parameters for PL/SQL mappings to obtain the best performance:

Option Name	Value
Deployable	TRUE
Step type	PL/SQL
Default operating mode	Set based fail over to row based For Update statements this doesn’t works. So it need to be “Row based (Target only)”
Generate bulk processing	False for the mappings processing less no. Of records,
	true for mappings processing large number of rows (sales fact)
Bulk size	100 This value has to be matched with Commit Frequency if not it gives a warning. So for facts this value will be 1000.
Default audit level	Complete
Commit Frequency	100 for dimensions, 1000 for Sales Fact
Generate analyze table statement	FALSE
Max no. Of errors	50
Bulk processing	TRUE
Analyze table statistics	Default value
Analyze table statistics	Default value