DSXchange

Hi Friends,
I have one problem in work, please can help to me in solution.

i have 3 TABLEs, i am storing data from 1st table to 2nd table. in the job. here i need start_time and End_time of job which is picking data from TABLE1 and putting data in to TABLE2

These Start_time and End_time i need to maintain in TABLE3.

you'll prob need a sequencer to get the start and end time of the job cos the end time of a job is only known after job has finished.
try doing a search on etlstats.

You can also pick them up using DataStage macros (such as DSJobStartTimestamp) or equivalent DataStage API functions (such as DSGetJobInfo() function), both of which are available in expressions in job sequences.