Source is BigInt and Target is Number(38)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Source is BigInt and Target is Number(38)

Post by satheesh_color »

Hi All,

My source table is DB2 and my target table is Oracle 11g.

My ID columns in source tables are BigInt and Target columns are number(38).

When I do CDC, can you please let me know the best way to do the conversion and insert/update into the target table(Oracle) to number.


Kindly let me know your thoughts on the same.


Regards,
Satheesh.R
Post Reply