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 Member]

Hello Vinod,

Can you elaborate a bit more on your job design? When you say last loaded date, is it different from load_date? Are you loading datetime or just date?

Best!

Pradeep

[Former Member]

Hi Pradeep,

my project is dealing with full data load from source to target (No transformation or any other logic's in my project).

so I am using only query to map the columns, but including the new columns for updated date and load date.

For this both columns I have given sysdate() to display date of the load.

this is the process I am doing now.

let me know if want more details.

by,

Vinodh

[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.

[severin_thelen]

Do you use table comparison or something like this? Maybe your rows are not updated.

It would help, if you could tell more about your job

• which transforms?
• any logic?

Regards

Severin