| Loading data into 2 different schemas [message #188582] |
Sun, 20 August 2006 02:40  |
hsejar1210
Messages: 4
Registered: August 2006
|
Junior Member |
|
|
ALL,
I am new to OWB, Can someone pls tell me how to load data nto 2 different schemas through a single mapping without making use of synonyms.
Ex.
DATABASE D1
Schema SCOTT
Table Emp
DATABASE D2
Schema Scott1 Scott2
Table Emp1 Emp2
Now i want to load data from scott.emp into scott1 .emp1 which will contain records pertaining to dept nos 10,20 and scott2.emp2 which will contain records pertaining to 30,40,50.
1.Is it possible to load data into 2 different schemas thru a single mapping ? If yes, then  tell me how ?
ALSO tell me when you are creating the target schema thru' runtime assistant will you take it as scott1 or scott2 ?
Thanks in advance,
RAJESH
|
|
|
|
| Re: Loading data into 2 different schemas [message #191593 is a reply to message #188582] |
Thu, 07 September 2006 03:50  |
jvalerof
Messages: 9
Registered: September 2006
|
Junior Member |
|
|
Hi RAJESH,
yes, you can load data from one schema to 2 schemas. You can:
1. Define 1 source module (SC_MOD: where is source data)
2. Define 2 target modules (1 target module for every schema)
3. You define 1 mapping between source module and every target module.
4. You can add any filter you want to load desired data in any target module.
Greetings
|
|
|
|
| Re: Loading data into 2 different schemas [message #356026 is a reply to message #191593] |
Wed, 29 October 2008 01:44 |
mca.nitesh
Messages: 6
Registered: October 2008
Location: Delhi
|
Junior Member |
|
|
| jvalerof wrote on Thu, 07 September 2006 03:50 | Hi RAJESH,
yes, you can load data from one schema to 2 schemas. You can:
1. Define 1 source module (SC_MOD: where is source data)
2. Define 2 target modules (1 target module for every schema)
3. You define 1 mapping between source module and every target module.
4. You can add any filter you want to load desired data in any target module.
Greetings
|
Sir i to have same and in following the same steps as u've mentione d validation,mapping and deploy is sucessful but data doesn't get loaded. please help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
