last updat and load date

dr46014 · Post by **dr46014** » Mon Dec 18, 2006 1:32 am

hi all
i need to update my table with last update date and datawarehouse load date.how can i achieve this functionality with time stamp.plz suggest me the functions :D

I_Server_Whale · Post by **I_Server_Whale** » Mon Dec 18, 2006 2:29 am

Its not really lucid on what your problem is. Per my understanding, you can use DS Macros, either 'DSJobStartDate' or 'DSJobStartTimeStamp'.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 18, 2006 2:32 pm

You can supply these to the job doing the updating as job parameters, or calculate them within the job.

The actual format that you need to supply to the database will depend upon which database you're using, which information you opted not to reveal.

But it should be a straightforward update executed through the appropriate stage type.