We are working with implementing multiload as part of our ETL processes (we have traditionally just used fastload). When running multiload, what are the considerations and/or limitations associated with running multiple multiload jobs in parallel? We would be executing these jobs logged onto Teradata as a single user. If anyone has suggestions for the optimal way to do this, I would really appreciate hearing whatever you have to share.
The first thing that comes to mind is the load tasks limit. I can't remember what it is off the top of my head, but you can only have a certain number of concurrent load jobs running at once. Once you hit that limit, any subsequent jobs will error out when they try to initiate. Check with your DBAs about what that limit is and try to architect your jobs to stay under that limit.