Generic script to load file details(ls -ltr) in to a database.

UNIX for Beginners Q & A
1

All,

I am trying to create a report on the duration of an ETL load from the file arrival to the final dump in to a database for SLA's.

Does anyone have any guidance or ideas on how metadata can be extracted; information of a file: like file name, created timestamp, count of records and load into a table ? (oracle or teradata).

Thanks in Advance!

2

Hi pradeepp,

Sorry, UNIX.com is not a script writing service.

We are here to help you write your own scripts and to admin your own systems; but you need to do your own work.

If you want to write a script and ask for help and comments on your work, please do so. That is how we work here.

Thanks.

PS: Don't forget to search the forums before asking questions.