I am new to Datastage Development. I have a requirement to create multiple files from a single big file.
I am planning to do as below.
1000(This will change everyday, may be next day 15k records come) records file is there.
I need to create dataset of 250 records each.
Job parameter pRecord =1 specified
in transformation I will perform @recordcount MOD 250. If the value is zero then pRecord =pRecord+1
My problem is how to change the job parameter pRecord and I am also using pRecord in my dataset name also.
Example:- TargetDS#pRecord#.ds
DS job output will be TargetDS1.ds, TargetDS2.ds, TargetDS3.ds and TargetDS4.ds (for 1000 records, this can be changed based on the records)
Please help me on this or suggest any good easy way to do.
Best way? Use a Server job and write to a Folder stage, it can handle the automatic file splitting and naming based on data elements for you. IMHO, of course.
-craig
"You can never have too many knives" -- Logan Nine Fingers