ETL Load time (Timestamp ) variations

sajidkp · Post by **sajidkp** » Mon May 25, 2009 4:50 am

HI,

I have a Loading job in which i need to load a column called ETL_Load_Time . The problem is i have a huge data. So if i use the currenttimestamp() function as the loading time changes the "seconds" parts of tmestamp change. Is there any way to get same value for all the record loaded at a time, i mean some thing like sequencer start time or something like that?.. please help me if anybody have an idea.

Jasti · Post by **Jasti** » Mon May 25, 2009 4:57 am

You can use DSJobStartTimestamp instead of CurrentTimestamp(), it's there in DS Macro.

sajidkp · Post by **sajidkp** » Mon May 25, 2009 5:06 am

Jasti wrote:You can use DSJobStartTimestamp instead of CurrentTimestamp(), it's there in DS Macro.

Thanx alot Mohan.A.Jasti,

This has solved my problem. As iam new to DS i dont have exact idea of the functions in DS. thats why i asked this simple question.