Unanswered: Best practice for this replication scenario
I need to replicate about 1.5 million records every night from an Informix database to my Oracle 9i database. Informix runs on AIX and Oracle on Solaris.
I have looked at Transparent Gateways and also wondered if I shouldn't try a java procedure to connect to Informix via JDBC and then select/insert the records (not sure if I can do that)
The data in my DB will be truncated before each replication.
I have no access to the Informix database or box...only a view. The Oracle DB is mine.