I would change the generic job so that array size is a job parameter. Use a parameter set with a value set for each table so that array size can be set on a per table basis.
That may work. Just keep in mind the LOB settings in Connector stages. Sometimes you have to name or choose which columns are the LOB columns. It means having separate jobs unless you can parameterize that setting too (haven't tried it).
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky wrote:That may work. Just keep in mind the LOB settings in Connector stages. Sometimes you have to name or choose which columns are the LOB columns. It means having separate jobs unless you can parameterize that setting too (haven't tried it).