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
connecting to MYSQL DATABASE
Moderators: chulett, rschirm, roy
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: connecting to MYSQL DATABASE
If MYSQL supports some sort of bulk load - Unload data from Oracle and bulk load it into MYSQL.vijaykumar wrote: I just want to dump the data from oracle to MYSQL.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.