Hi , I am new to data stage , I want to load the 360 tables from oracle to db2 tables in one or 2 jobs .please help me to design the Job .
Moderator: split from this post so you can have your own post / discussion / solution.
Load multiple tables from Oracle to DB2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If there are no large objects (BLOB or CLOB), and provided that you are using DB2 Timestamp data type where Oracle has TIME, you will be able to do this with one or two jobs quite easily using Runtime Column Propagation.
Even if there are large objects it can be achieved with few jobs, but you have to generate SQL (in a sequence, probably) to convert the binary data into hex encoded when selecting and back again when inserting.
I have done this, except that the target was MySQL.
Even if there are large objects it can be achieved with few jobs, but you have to generate SQL (in a sequence, probably) to convert the binary data into hex encoded when selecting and back again when inserting.
I have done this, except that the target was MySQL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I think the following link will help you
http://isecor.com/drupal6/node/163
Replace target by DB2 Stage
http://isecor.com/drupal6/node/163
Replace target by DB2 Stage