Thats fine. i have generated a text file with yesterday's date and loaded the date using lua script.
that has done the job for me.
------------------------------
R G
------------------------------
Original Message:
Sent: Thu April 11, 2024 05:32 PM
From: Jimmy Wilson
Subject: optim column map CurDat function
RG,
You are correct and I am surprised. When you save the syntax and simply reopen it, the -1 part of the entry is gone.
I guess you would have to resort to a small Lua script to do this aging.
Or you might open a trouble ticket to see if that is the correct behavior.
-- Jimmy Wilson
![]()
1999 S. Bascom Ste 700
Campbell, CA 95008
Phone +1(972) 567-5558
jwilson@abmartin.com
Confidentiality: This transmission, including any attachments, is solely for the use of the intended recipient(s). This transmission may contain information that is confidential or otherwise protected from disclosure. The use or disclosure of the information contained in this transmission, including any attachments, for any purpose other than that intended by its transmittal is strictly prohibited. Unauthorized interception of this email is a violation of federal criminal law. If you are not an intended recipient of this transmission, please immediately destroy all copies received and notify the sender.
Unstructured Data Masking
Data Privacy/Test data Management - fabrication, optimization, obfuscation
Original Message:
Sent: 4/11/2024 4:29:00 PM
From: R G
Subject: RE: optim column map CurDat function
Hey Jimmy, Thanks for quick response. i have tried the option, it didnt throw any validation error.
but surprisingly once I save and run the job , "-1" disappears from column map.
------------------------------
R G
Original Message:
Sent: Thu April 11, 2024 03:35 PM
From: Jimmy Wilson
Subject: optim column map CurDat function
RG,
You might try something like CURDATE()-1.
That should do the trick for you.
-- Jimmy Wilson
![]()
1999 S. Bascom Ste 700
Campbell, CA 95008
Phone +1(972) 567-5558
jwilson@abmartin.com
Confidentiality: This transmission, including any attachments, is solely for the use of the intended recipient(s). This transmission may contain information that is confidential or otherwise protected from disclosure. The use or disclosure of the information contained in this transmission, including any attachments, for any purpose other than that intended by its transmittal is strictly prohibited. Unauthorized interception of this email is a violation of federal criminal law. If you are not an intended recipient of this transmission, please immediately destroy all copies received and notify the sender.
Unstructured Data Masking
Data Privacy/Test data Management - fabrication, optimization, obfuscation
Original Message:
Sent: 4/11/2024 2:56:00 PM
From: R G
Subject: optim column map CurDat function
Hello All,
We are trying populate yesterday date into one of the column in oracle. using column map in optim 11.7
We could see that there is an option to load CURDATE which loads todays date, but couldn't find a way to subtract a day from current date.
is there a way, we can get the yesterday date or subtract a day from CURDATE and load into oracle target database.
------------------------------
R G
------------------------------