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