DSXchange

It will be great if we can able to remove places. Now I am not able to view data in unix environment but only able to view it from sequential file in dsjob after job run.

It is not related to any of my previous posts. I have a target table(oracle) which keep track of all loaded accounts. In that I have a column for endtimestamp.

Could somebody help me in this regard.
Either something we can do in transformer or after job subroutine

thank you guys,
I was able to resolve by passing timestamp to file name.
For everyjob run it is creating newfile with updated timestamp.
I put the file name as \pathaname\#DSJobStartTimeStamp#

thanks again

Could somebody please provide me after job script to rename the file immediately after each job run.

Hi,
Thanks for your reply.
Do we need to send DSjobstarttimestamp as parameter in the job to give it as file name to reject file.
Please explain me how the file name get the timestamp at runtime and what needs to be done to achieve this

Hi,
I have to get Job end timestamp once the job completed successfully.
Is there anything in transformer stage we can do about it.

Thanks,
Sridhar

Hi, I am passing Jobstarttimestamp to reject file. I want to split the file based on Jobstarttimestamp. If job run now and then again run after few minutes I want to spilit them into two files, because the job run two times. Means I want to spilit the file for each time job runs. I have the DSjobsta...

Hi, Thanks for your reply. I want to partition it based on timestamp. After Lookup, whatever records failed in lookup are going to a transformer using reject link. In transformer I am creating timestamp and sending it to reject file. So, I want to partition the file based on that timestamp. Because ...

Hi, I am loading rejected records into sequential file. Once the data is loaded, I want to seperate them based on timestamp. I have column for timestamp in rejected file. Could anyone help me in writing unix script to partition the file based on timestamp after the datastage job is finished. Thanks,...

Hi, I have the following requirement. I have a lookup stage and in stage properties I put if look up fails then go to reject link. In the reject link I put sequential file. The data is huge and I have to set size limit on sequentail file in reject link as 2MB and once it reaches the 2MB limit it has...