DSXchange

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..

Try starting with some searches on "RCP."

Also known as Runtime Column Propagation which is (as noted) what you need to fulfill this requirement. It's all documented plus has been discussed here ad nauseam so there's plenty of information on it to go around.