I am trying to add Create_Date and Update_Date columns for each occurrence of file.
1st execution- For every new file or record Create_Date and Update_Date will become the system timestamp.
2nd execution- For the same file, same data is occurring then only Update_Date will update, but the Create_Date will remain same for all the same records on the same data set.
3rd execution- If the partial records are new, then for all the records, Update_Date will be system timestamp, but the Create_Date will be populated only for new records, for the older records it will be same as old on the same data set.
Input is excel file.
output is sql table in pgadmin.
-> I am using "Update: insert if new" configuration for the Update_Date column but not sure on Create_Date column.
Please suggest some idea.
Thanks! in advance.
