Ds job should run daily and pick the current date file.
Moderators: chulett, rschirm, roy
Ds job should run daily and pick the current date file.
Hi,
I have a requirment as explained below:
Question : Daily files are placed in '/tmp/ds/sources/' the files are in .csv formate
I have to dev a Datastage job (and load to the path '/tmp/ds/target/') in such a way the job should run daily and should pick the present date file, if i did not get a file on the perticular day it should NOT pick the old file and more over the job should not run on that day (because no file exists on that day).
for example the source files are :
source_mrc_06_02_2012.csv
source_mrc_07_02_2012.csv
source_mrc_08_02_2012.csv
'
'
'
'
Please could expertise explan me how to approach this requirement.
Thanks in advance.
cheru.
I have a requirment as explained below:
Question : Daily files are placed in '/tmp/ds/sources/' the files are in .csv formate
I have to dev a Datastage job (and load to the path '/tmp/ds/target/') in such a way the job should run daily and should pick the present date file, if i did not get a file on the perticular day it should NOT pick the old file and more over the job should not run on that day (because no file exists on that day).
for example the source files are :
source_mrc_06_02_2012.csv
source_mrc_07_02_2012.csv
source_mrc_08_02_2012.csv
'
'
'
'
Please could expertise explan me how to approach this requirement.
Thanks in advance.
cheru.
Cheru
I would argue against a "current date" file check but would implement an "unprocessed" file check. Move/archive the files elsewhere after processing so that anything found in that directory needs to be loaded, this allows you to catch up if need be.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Ds job should run daily and pick the current date file.
Hi,
Please revert me with the solution for the requirement above.
Regards,
Cheru.
Please revert me with the solution for the requirement above.
Regards,
Cheru.
Cheru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: