Archives of the TeradataForum
Message Posted: Fri, 15 Mar 2002 @ 16:50:09 GMT
I've worked with a few customers who load from multiple platforms. Given that there are technically a multitude of ways to get the data into Teradata, most client platforms have the normal utilities available on them, typically the most difficult part of doing this is to overcome any scheduling/table lock conflict type problems.
For instance if you need to load the same table from data held on MVS and Unix then that potential problem has to be overcome.
There are some cross-platform schedulers (control-m for one, I think CA's CA-7 now has this capability as well) which can help in this area.
One site I worked with loaded their data from each source system UNLESS there was this type of conflict in which case they ftp'd it to a single platform and let the scheduler there control the various jobs.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023