Scribd
Upload
67 views1 page

IT Professionals: Interface & Conversion

Interface is a scheduled, periodic process that transfers data between a legacy system and Oracle system an unknown number of times per specified period. Conversions is a one-time activity used for upgrades and migrations where the flat file volume is known, and is not scheduled like interfaces. SQL Loader loads data from flat files into Oracle tables and produces log, bad, and discard files.

Uploaded by

Srikkanth Mani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
67 views1 page

IT Professionals: Interface & Conversion

Interface is a scheduled, periodic process that transfers data between a legacy system and Oracle system an unknown number of times per specified period. Conversions is a one-time activity used for upgrades and migrations where the flat file volume is known, and is not scheduled like interfaces. SQL Loader loads data from flat files into Oracle tables and produces log, bad, and discard files.

Uploaded by

Srikkanth Mani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Interface & Conversion

---------
Interface:

Interface is periodic activity, it may be daily or weekly or monthly or quarterly


or [Link] Legacy system and oracle system are [Link] is Scheduled
Concurrent Process to execute multiple [Link] will not be knowing the volume of
the Flat file.

Conversions:

Conversions is one time [Link] is used in Upgrade and Migration [Link]


will be knowing the volume of the Flat [Link] is not a Scheduled Process.

SQL Loader
----------

sqlldr apps/apps@SERVICE_NAME

[Link] File
[Link] File
[Link] File

You might also like