Hi All,
There is a requirement in my Project, we have source Oracle and Target SQL server. In both tables metadata same.
Say in Oracle table 1 having columns
Table 1
-------------------
A NUM 10
B Varchar 20
------------------
Table 2
--------------
A Num 10
B Varchar 20
C Char 10
---------------
and same fields in target SQL server. We need to do in one job to load all 100 tables.
Please share some idea how to proceed..
Required a Generic Job to load 100 tables
Moderators: chulett, rschirm, roy