Merging oracle two table from different schema into new schema

Anonymous — Sat, 16 Nov 2024 13:52:10 GMT

Hi, could someone guide me in the right path as im newbie using this application i know a bit of MSSQL DTS it seems look the same but the methods is about confusing me. I have a similar scenario like the tables below. Where my main purpose is to merge two database and create a new database with combined data records. Could someone guide me to the step to achieve this task which component should i use.

ORACLEDB1
TBLMASTER - Master list table
ID FIELD1
1 CAR1
2 CAR2
3 BLACK
4 WHITE
5 HAWK
6 TIGER
TBLASSOC - Association table parent<->child
P_ID C_ID
1 4
2 5
3 6
ORACLEDB2
TBLMASTER - Master list table
ID FIELD1
1 CAR3
2 CAR4
3 BLUE
4 YELLOW
5 WHALE
6 FIN
TBLASSOC - Association table parent<->child
P_ID C_ID
1 4
2 5
3 6

ORACLEDB3 FINALOUTPUT
TBLMASTER - Combined master list table
ID FIELD1
1 CAR1
2 CAR2
3 BLACK
4 WHITE
5 HAWK
6 TIGER
7 CAR3
8 CAR4
9 BLUE
10 YELLOW
11 WHALE
12 FIN
TBLASSOC - Combined Association table parent<->child
P_ID C_ID
1 4
2 5
3 6
7 10
8 11
9 12

Any help is highly appreciated.
Thanks

topic Merging oracle two table from different schema into new schema in Talend Studio

Merging oracle two table from different schema into new schema