DSXchange

Dear All,

I have 8 Databases in source sql server and i need to load in oracle db which is target.I already loaded 1 db and i need to load other db data into the target which is oracle.
as i have same metadata ,there is a confliction while i load data into oracle where second db tables will have same key values as in first db.

i want to to :

1.what is the best way to access these 8 db's to load in oracle.
2.how to resolve the conflication about validating the same records already exists in db and i could not load it agian.

how can we achieve in owb.

any help on this

Patience is a virtue. This is an all-volunteer site.

1.) Use same job with different connection parameters which can be change during runtime
2.) Include any unique value in connection parameter - say dbname - as part of the key

The best way to restrict the rows is by doing a lookup.