Tricky Requirement
Posted: Fri Feb 10, 2006 2:29 pm
Hi
I have a requirement as follows:
We have a Directory called "REP" in which there are 200 Sub-Directories each for one customer. In each Sub-Directory they have 4-5 reports generated bi-weeekly for every customer by Oracle. In those reports few of them are generated in PDF format and few of them are generated in .TXT format. All these Reports need to be Archived at some different location, Need to convert all the .TXT Reports into PDF foramat and need to attach these Reports to an E-mail and forward them to corresponding Customers. All the Sub-Directories have the standard naming convention(e.g: mnc1100, mnc1210,mnc2555....). Reports does not have any standard Naming Convention.
Note: Currently All the above process is performing manually.
Now my requirement is to automate all the above process using Shell Script and DataStage. Here in this scenario, i dont think DataStage helps us a lot, Am i correct?
Iam ambigous to handle this task in a folder level or a file level.
Can anyone give me any suggestions!!!
Thanks in Advance...
Viny
"You must be the change you wish to see in the world."
--Mahatma Gandhi
I have a requirement as follows:
We have a Directory called "REP" in which there are 200 Sub-Directories each for one customer. In each Sub-Directory they have 4-5 reports generated bi-weeekly for every customer by Oracle. In those reports few of them are generated in PDF format and few of them are generated in .TXT format. All these Reports need to be Archived at some different location, Need to convert all the .TXT Reports into PDF foramat and need to attach these Reports to an E-mail and forward them to corresponding Customers. All the Sub-Directories have the standard naming convention(e.g: mnc1100, mnc1210,mnc2555....). Reports does not have any standard Naming Convention.
Note: Currently All the above process is performing manually.
Now my requirement is to automate all the above process using Shell Script and DataStage. Here in this scenario, i dont think DataStage helps us a lot, Am i correct?
Iam ambigous to handle this task in a folder level or a file level.
Can anyone give me any suggestions!!!
Thanks in Advance...
Viny
"You must be the change you wish to see in the world."
--Mahatma Gandhi