Get the data into data file while uploading

[JobHelper]

How can we get the data into data file while uploading the data from legacy systems to apps base tables.
What are the steps involved in getting the data into data file.

NOTE : [This question was asked by viswanath]

[siva sankar]

Hi,

first we get the flat file from the client.(i.e .dat,.txt),
then we create the staging table and upload the data from flat file to staging table using sql*loader.

if any queries please let me know..
Thanks,
Siva Sankar