How conversion/Migration and interface differ?
There are good numbers of parameter on which they can be categorized. Take few of them: Frequency • Conversions/Migration are a one time event • interfaces are ongoing Occurrence in the project timeline • conversions/Migration executed before production • interfaces executed during production Manner of execution • Conversions/Migration are batch • Interfaces may be batch or real time Complexity • Conversion/Migration does have very complex, it’s totally depends upon the data mapping activity. • Coordinating with other systems make interfaces more complex Maintenance • Maintenance of interface is bit cost intensive task. Interface Type: There are two types of interfaces: • Inbound • Outbound Inbound Interfaces: An inbound interface receives data from one system (legacy) into Oracle open interface tables. A typical inbound interface would follow these steps: • Extract data from legacy system into a flat file. • Use SQL*Loader or equivalent tool to upload information into a temporary tabl
