File validation
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 32
- Joined: Tue Mar 09, 2010 5:56 am
- Location: Bangalore
File validation
I need to validate some source files with a single file which is having the details of the source file for e.g file name and record count of the source file and only the correct files will be processed for the next level.How can I implement the same in datastage windows environment.
Thanks & Regards,
Partha
Partha
So you are saying you have one file that identifies the source files that you should process? Does this one file contain only the files that should be processed? Or contain other file details too? A sequence to control this file list would be the easiest approach... there is a file pattern which can read a file list but I think that expects only file names not other details associated to the files...
Re: File validation
It seems you are getting a control file for the data file. if you have less info like data file name, record count and arrival time then i would suggest to do the data validation by using unix script. Also you need to check for the size of the data file. if it is huge or in GB you can create a temp table to dump the file and do the validation
grimm