Hi All,
We have the website.
We are doing below work:
fetching the data files from ftp server.
Doing some checking(logical, Business rules, data type) on files.
loading the data into tables with the help of sql loader, procedures, packages etc.
During loading we are doing some transformation also in procedures, packages.
After loading sending mails to users if it is successful and if its failed we are sending failure messages also.
That is the basic work all we are doing through shell scripts.
My question is Can We use ETL tool to do all this work. Also Can any free tool available in market to do these tasks.
Thanks in Advance.