HI,
I created a generic load job which loads source table into target table.
This job should loads mutiple source tables from one server into multiple tables in another server .
Please let me know how can this be achieved .
Thanks in advance.
Thanks
Sunitha
multiple instance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Just curious, have you tested it with more than one table? Also, are there likely to be any "troublesome" columns, such as BLOB data type, that might bite you?
The short answer is: run it multiple times.
If you require these to be simultaneous, then create the job as being enabled for multi-instance operation.
The short answer is: run it multiple times.
If you require these to be simultaneous, then create the job as being enabled for multi-instance operation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I have already given my (complete) answer. Get yourself a premium membership so that you can read it. Premium membership is inexpensive (less than Rs12 per day) and helps to defray the hosting and bandwidth costs of DSXchange.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.