DSXchange

HI,

my source is oracle and my target is MYSQL.when iam using ODBC to connect to both oracle and MYSQL, iam getting many column datatype mismatch.I already have metadata defined in MYSQL.I just want to dump the data from oracle to MYSQL. How to deal in such situations and which is the best ideal source stage to connect to MYSQL.

cheers;
vijay

Import meta data rather than defining it yourself.
Oracle and MYSQL are two different database. They will have data type mismatches. Thats where DataStage comes in and does data conformity. Use the rich functions of datastage to get that done.

vijaykumar wrote: I just want to dump the data from oracle to MYSQL.

If MYSQL supports some sort of bulk load - Unload data from Oracle and bulk load it into MYSQL.