Question
I am mapping the current date and time to multiple script variables using only one Current Date/Time logic in the same mapper to output the time of execution of a process.
However, the time set varies depending on the script variables.
What can I do to set the same value?
Answer
Mapper obtains values from the input source schema and logic mapped in order for each script variable and column in the output destination schema.
If the Current Date/Time logic is mapped to multiple script variables and columns, the timing of obtaining values from the logic differs for each script variable and column.
As a result, output results may differ for each script variable and column.
■Measures
To set the same value for the script execution time, add a new script variable and set the value to that script variable from the Current Date/Time logic.
Then, put values from that script variable to other columns or script variables.
Comments
0 comments
Article is closed for comments.