sysdate was not updating while loading

[#1]

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