| Oracle vs Informix [message #365444] |
Fri, 29 May 1998 13:08  |
Janie
Messages: 2
Registered: May 1998
|
Junior Member |
|
|
|
I currently maintain an Oracle DB running SAP. Another group wants to build a data warehouse of the SAP data possible using Informix. I want them to stay with Oracle. What are the issues of extracting data from Oracle and populating an Informix DB? They may also want to send updates from the warehouse back to Oracle. Your help is appreciated.
|
|
|
|
| Re: Oracle vs Informix [message #365467 is a reply to message #365444] |
Tue, 23 June 1998 15:14  |
ravikumar
Messages: 17
Registered: June 1998
|
Junior Member |
|
|
Well, For extracting data from Oracle - Write a sql script and save the ouptput into ascii flat file .
For populating Informix DB - write a 4gl program and using LOAD command you can populate the database.
Depending on the nature of updates that you receive from warehouse, use Pro*c or Sql Loader to update you oracle database.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
