SQL Loader – Unix Script – Loading Multiple Data Files in Oracle DB Table

Here I am going to show the power of SQL Loader + Unix Script utility where multiple data files can be loaded by the SQL loader with automated shell scripts. This would be useful while dealing with large chunks of data and when data needs to be moved from one system to another system.

It would be suitable for a migration project where large historical data is involved. Then it is not possible to run the SQL loader for each file and wait till it's loaded. So the best option is to keep the Unix program containing the SQL loader command running all the time. Once any file is available in the folder location then it will pick up the files from that folder location and start processing immediately.

Compress File Using Mule 4 With AES 256 Encryption

In this article, I will discuss the process of zipping a file using Mule 4 with AES 2565 encryption.

Here is the background in some cases after generating the output file in the Unix server.
the file needs to move to a window's location for business, to which the developer team does not have access.