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.
Loading 8 databases data into oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore