Need to load sequential files to Oracle database daily.

Virupan · Post by **Virupan** » Wed Jan 21, 2009 1:06 am

Hi All,

I have to load one dat file to oracle table on a daily basis.The filename is having the timestamp in it.I have to create a job sequence to automate the process of loading each file to oracle table on a daily basis.I have a column as 'AHM_file_name' in the target table which I am hardcoding while loading a file individually.I want to automate the process of loading completely with each day file name with timestamp captured in the column mentioned.

Thanks
Virupan

ray.wurlod · Post by **ray.wurlod** » Wed Jan 21, 2009 1:36 am

Welcome aboard.

There are many possible solutions, but probably the easiest is one that moves the file to a different directory once that file has been processed. Then you can simply grab "the" file in its directory. Use an ls command to get the file name.

Otherwise you can generate the timestamp part of the file name, and therefore the entire file name, perhaps in a User Variables activity.

Search DSXchange for examples of these techniques.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 21, 2009 1:38 am

There's a webinar available at the DSXchange Learning Center dealing with handling files from DataStage job sequences.