Home » Developer & Programmer » Warehouse Builder » Loading data into 2 different schemas
Loading data into 2 different schemas [message #188582] Sun, 20 August 2006 02:40 Go to next message
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 Embarassed 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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: help requiered
Next Topic: Help required
Goto Forum:
  


Current Time: Thu Jul 31 11:18:34 CDT 2014

Total time taken to generate the page: 0.08501 seconds