sysdate was not updating while loading

[Former Member]

Hi Team,

I am extracting data from SAP ECC and loading it in Oracle database.

For every table I have included 2 columns. one for load_date and another for update_date.

for both columns i have hard coded as sysdate(). it will displaythe system date, but some time it is showing the last loaded date.

kindly help me on this.

Thanks and Regards,

Vinodh Seemakurthi

[former_member187605]

In any case,this is not good practice. Using sysdate() in a mapping will result in evaluating the function for every record retrieved. Even twice in your case!

It's much more efficient to assign the sysdate to a global variable, in a script before the data flow, and then use that variable in the mappings. All your records processed in a single job execution will then contain exactly the same value for load_date and update_date columns.